Can I use Oracle JDBC 12.1.0.1 (for 12c database) on a Oracle 10g database?

java oracle jdbc oracle10g oracle12c
humungs picture humungs · Jul 16, 2014 · Viewed 20.9k times · Source

Just a simple question (I guess). Oracle released a new JDBC driver for Oracle Database 12c including a Java 7 JDBC driver (ojdbc7 - 12.1.0.1). Here, we've been using Oracle 10g database with ojdbc6 for Oracle 11g (11.2.0.4) without any problem. Now, my questions.

If I upgrade my application server to use ojdbc7 for Oracle 12c, is it too risk? Does the Oracle maintains compatibility of their drivers with previous versions?

Answer

Joshua Huber picture Joshua Huber · Jul 16, 2014

Yes. This is officially supported per Oracle. http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#01_02

Related questions

JDBC Batch insert exception handling

I am performing a JDBC batch insert (inserting 1000 rows approx at a time) each time my program is executed. But i am not able to handle the exception thrown by some of the records properly. Suppose, the 100th record out …

Read More
Java JDBC - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I …

Read More
java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

I am getting an ORA-01000 SQL exception. So I have some queries related to it. Are maximum open cursors exactly related to number of JDBC connections, or are they also related to the statement and resultset objects we have created …

Read More