Is OJDBC7 Compatible with Oracle18c?

Question

Currentlt, I have an Oracle Database Server (11g) and many differen Java 8 Applications on client computers. These applications mostly use ojdbc7.jar for database query execution.

Now, we are facing an incoming migration to Oracle 18c. We will work on updating dependencies for these applications, to ojdbc8.jar; however I need to know whether this is a blocking point for new version integration.

Will ojdbc7 dependency work with Oracle 18c, albeit, with limited functionality? Or is it absolutely necessary to update dependency BEFORE server migration?

Hope you can shed any light on this.

user_4612499 · Answer

You can continue to sue ojdbc7.jar from 11.2 to connect to an Oracle 18c Database. That's supported but some new functionalities in 18c won't be available. Eventually you should also upgrade the client (ojdbc8.jar).

user_3557631 · Answer

ojdbc8.jar: Certified with JDK9 and JDK8, all the classes to support basic functionality for the Thin driver. Additional jar files are required when you use some features

Source: https://www.oracle.com/database/technologies/faq-jdbc.html#01_03_1

user_4393594 · Answer

Refer to the JDBC FAQ for more compatibility question. I have pasted here fore details.

Is OJDBC7 Compatible with Oracle18c?

3 Answers