Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between ojdbc6.jar and ojdbc7.jar?

Tags:

java

ojdbc

jdk1.7

Will ojdbc6.jar work for JDK 1.7 and Oracle 12c? Should I use ojdbc7.jar?

Thank you in advance.

like image 247
Brooke Avatar asked Aug 11 '15 00:08

Brooke


People also ask

What is ojdbc6 jar?

The "ojdbc6. jar" file constitutes the Oracle thin client-side JDBC driver which is compatible with Java 6 (JDBC level 4.0). For more information, read the Oracle JDBC FAQ. 1-Thereareacoupleofissuesthatmakecross-databasecompatibilitydifficulty.

Is ojdbc7 jar 12c compatible?

for Oracle 12c there is also an ojdbc7. jar available which will only work when running with Java 7 or newer. This one was been introduced with Oracle 12c. The Jars can be downloaded from Oracles download section which requires a free registration.

Is ojdbc6 compatible with java 8?

0.2. 0 - 64bit Production with an IBM WebSphere application which runs with Java 8 and everything works fine with the ojdbc6.


3 Answers

The included ojdbc6.jar is the latest 12c driver. The only difference between ojdbc6.jar and ojdbc7.jar is that the latter one is compiled with Java 7. Since DB Solo is at least for now using Java 6, it can only include ojdbc6.jar. In terms of functionality the versions are identical. Link

like image 176
Anand Dwivedi Avatar answered Oct 23 '22 20:10

Anand Dwivedi


Note that another difference between ojdbc6 and ojdbc7 is the supported Oracle version.
Specifically ojdbc7 does not support Oracle 11.2 or 11gR2 whereas ojdbc6 does: source.

like image 20
RikH Avatar answered Oct 23 '22 19:10

RikH


For completeness, note that the number in the filename is NOT the version number of the driver and ojdbc6.jar version 12.x has a weird difference respect ojdbc6.jar version 11.x: newer versions do not truncate or set to "00:00:00" the time component when called with setDate and getDate methods, so you should pay attention to the version number too (you can find it in the manifest as "Implementation-Version"). See this post for more details.

like image 33
Pino Avatar answered Oct 23 '22 19:10

Pino