Can we use ojdbc14.jar with Oracel11g and jdk1.5

Question

I believe there are different flavors of this questions already asked, but I wanted to confirm this again as we are very close to our release and wanted to validate with the community

We have been using Oracle10g and java 1.5 for quite some time now with ojdbc14.jar. I know that ojbc14.jar is catered towards java 1.4. But thankfully we never saw any issue while using this with 1.5 version. Another reason for not moving to ojbc5 was the fact that we did not see ojdbc5.jar in the installed oracle 10g at all.

We have upgraded our DB to be 11g now and I did not see ojdbc14.jar. Does this mean we have to move to ojdbc5.jar?

We are willing to make the change. But can the people who made the switch confirm if they saw any issue when they changed the JDBC driver to ojdbc5.jar from ojdbc14.jar

Related to it, it would be good if someone can elaborate little more about dms flavors of this jar and how it is to be used.

Answer 1

Take a look at Oracle's JDBC drivers list. For 11g and 11g2, only ojdbc5.jar and ojdbc6.jar are listed. This could mean that only they are officially supported, so if you have problems with ojdbc14.jar, Oracle probably won't help you.

If Oracle's support is important for your management, I'd recommend upgrading to ojdbc5.jar.

Answer 2

ojbc14 should work just fine with Oracle11g. The primary differences between ojbc14 and later versions is the later version support newer versions of the JDBC API, as well as new features of the newer versions of oracle.

If your application gets along with ojbc14 as it is, there's little reason to upgrade the driver, other than the fact that it's always a good idea to try and track new revisions as they come along, to keep your system current.