Will ojdbc6.jar work for JDK 1.7 and Oracle 12c? Should I use ojdbc7.jar?
Thank you in advance.
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.
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.
0.2. 0 - 64bit Production with an IBM WebSphere application which runs with Java 8 and everything works fine with the ojdbc6.
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
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With