SAP Note 915079 - J2EE on Oracle: Updating the JDBC drivers

Component : Database Interface / DBMS for Oracle - Oracle

Solution : https://service.sap.com/sap/support/notes/915079 (SAP Service marketplace login required)

Summary :
This SAP Note provides guidelines for updating the JDBC driver in Oracle-based J2EE systems. Users needing to localize or update the JDBC driver should differentiate between the driver itself and its references. Since version 10.2.0.4, SAP recommends updating the entire Oracle Instant Client rather than individual JDBC drivers, which are part of the client installations available via SAP Service Marketplace. For J2EE engines version 7.00 and above, only specific driver files (ojdbc14.jar and ojdbc6.jar) are used, excluding older versions using classes12.jar. Localization of driver files should reflect the setup detailed in the system’s configuration, and updating the driver necessitates a system shutdown and backup of old drivers. For specialized applications like XI, re-deployment of JDBC drivers is required, which cannot be performed at the file system level.

Key words :
/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d88f, \usr\sap\<sid>\sys\exe\uc\<platform>\, /usr/sap/<sid>/jc<xx>, \usr\sap\<sid>\jc<xx>, dvebmgs<xx>/j2ee/configtooland search, entire oracle instant client installation, complete oracle instant client software, entire oracle instant client, oracle-based j2ee engine system, oracle instant client installation

Related Notes :

1262744ArrayIndexOutOfBoundsException:-32683 w/Oracle JDBC 10.2.0.4
1174491J2EE: Data corruption w/ Oracle JDBC < 10.2.0.4 and JVM 5.0
1079125EWA GCA Task of Solution Manager Diagnostics
1068391TIMESTAMP values off by one hour on SELECT via JDBC
1003198J2EE: Incorrect data with Oracle10g JDBC lower than 10.2.0.4
998004Update the Oracle Instant Client on Windows
950454Date problem on the J2EE and Portal applications using JDBC
939424J2EE: Data loss in BLOBs with Oracle 10g JDBC < 10.2.0.2
867976Changing JDBC driver on WEB AS Java 6.40/NW 7.0x/7.1x
867176FAQ: Oracle JDBC
819829Oracle Instant Client Installation and Configuration on Unix