Menu
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?
547
As Oracle support note "Client / Server Interoperability Support Matrix for Different Oracle Versions" ( Doc ID 207303.1 ), Oracle Client 12.1 does not support connections with Oracle DB servers 10.1 and below.
Which driver should I use? The best choice is to use Oracle JDBC thin driver. All the new enhancements and features are implemented only on JDBC Thin driver. If you are using a non-TCP/IP network you must use the OCI driver.
The JAR file for the Oracle driver is ojdbc14. jar. Configure the connection pool using the following settings: Name: Use this name when you configure the JDBC resource later.
Yes. This is officially supported per Oracle. http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#01_02
130
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
