Version of Oracle thin driver to use with Java 6

oracle jdbc oracle10g jdk1.6 java-ee-5

16,679

You can use ojdbc6.jar.

There are 3 Oracle JDBC drivers still being widely used:

ojdbc14.jar for projects with JDK 1.4
ojdbc5.jar for projects with JDK 5 (or 1.5)
ojdbc6.jar for projects with JDK 6 (or 1.6)

Even though you're using Java EE 5, if the relevant JDK is 6, then you match Oracle driver's version number with your JDK number.

Oracle has a FAQ on their JDBC drivers regarding driver and database compatibility. This part might be useful to you.

16,679

Author by

Aravind Yarram

Winner of Hackathon @ Kafka Summit 2016. 2nd Place, Neo4j Graph Gist Winter Challenge 2014. Data informed over data driven. Datasets over algorithms. Delivery over ceremonies. Metrics over anecdotes. Hypothesis over intuition. Evidence over experience. Trade-offs over trends. https://www.linkedin.com/in/aravindyarram

Updated on July 15, 2022

Comments

Aravind Yarram almost 2 years

We are upgrading from Java 1.5 to Java 6 and J2EE 1.4 to Java EE 5. We are using Oracle 10g. Java EE 5 only supports JDBC 3.0, but Java 6 supports JDBC 4.0. If I am running on a Java EE 5 server with Java 6, can I use the JDBC 4.0 API in my Java EE 5 web app?

Which Oracle thin driver should I use? Is it ojdbc6.jar from Oracle's download page? Is that compatible with Oracle 10g?