SAP Note 867176 - FAQ: Oracle JDBC

Component : Oracle -

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

Summary :
This SAP Note provides a comprehensive guide on managing Oracle JDBC connections, specifically targeting JDBC Thin Driver usage within SAP environments. It explains JDBC (Java Database Connectivity) and outlines the various drivers provided by Oracle, with a focus on the JDBC Thin Driver, which is supported by SAP for connecting to Oracle databases. The note details driver compatibility with Oracle database versions, JDK (Java Development Kit) requirements, and file naming conventions for different driver and JDK versions. Additionally, it provides information on locating JDBC Thin Drivers in SAP installation paths, updating drivers, and determining driver versions utilized by Java programs. Recommendations and prerequisites for successful configurations are also included to ensure optimal performance and compatibility across SAP systems.

Key words :
jdbc/pool/me1/password               jdbc/pool/me1/url, path               instance -> dispatcher -> server -> managers -> configurationmanager, java   unix/linux      javac -classpath <path, jdbccheckup   unix/linux      java -classpath <path, oracle version  jdk version   driver file name11, terms jdbc jdk thin driver reason, program    windows      javac -classpath <path, program    windows      java -classpath <path, jdbc/pool/me1/user, directory               /usr/sap/<sid> /jc

Related Notes :

1003198J2EE: Incorrect data with Oracle10g JDBC lower than 10.2.0.4
950454Date problem on the J2EE and Portal applications using JDBC
941594J2EE: External Oracle databases as JDBC DataSources
939424J2EE: Data loss in BLOBs with Oracle 10g JDBC < 10.2.0.2
922080OOM in SAP J2EE applications on Oracle 9i
915079J2EE on Oracle: Updating the JDBC drivers
599110Data corruption using JDBC and NCLOBs
509719How to install Oracle JDBC Drivers