Sunday, October 17, 2010

Database Drivers and JDK specifications

On different oracle jdbc bundles. Must read:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#02_07
Why couldnt I understand the naming convention of jars before:

ojdbc6.jar - All the classes to support basic functionality for the Thin and OCI drivers when using JDK 1.6 (JSE 6)
ojdbc5.jar - All the classes to support basic functionality for the Thin and OCI drivers when using JDK 1.5 (JSE 5)
classes12.jar - Classes for the Thin and OCI drivers when using a Java 1.2 or 1.3 VM.
ojdbc14.jar - Same as classes12.jar except for use with Java 1.4 VMs

More dependencies for OCI:
libocijdbc.so (Solaris)Native library for the JDBC OCI driver.

* for JDBC 8.x.x drivers, the is 8
* for JDBC 9.x.x drivers, the is 9
* for JDBC 10.x.x drivers, the is 10
* for JDBC 11.x.x drivers, the is 11

This file should be locatable via your LD_LIBRARY_PATH setting.

ocijdbc.dll (Windows)Similar to above, except on Windows platforms. This file should be locatable via your %PATH% setting.