Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle JDBC choices: OCI or Thin (ojdbc6.jar), Oracle 11g R2, Java6-7 ?

801904Dec 4 2012 — edited Nov 20 2014

Hello Everyone

I did a search on this forum regarding which Oracle JDBC driver to use (from the application servers) - the OCI-based or Thin JDBC and the topic has been covered a number of time but the answers were several years old (most recent in ~2008?) so I would like to resurrect this topic again, for the later versions of Java (1.7 or at least 1.6, using ojdbc6.jar or later) and using the latest version of Oracle 11g R2 (11.2.0.3) database and latest OCI 11g R2 client software.

Which JDBC solution is recommened for the latest versions of Java and Oracle - to use Thin driver or use OCI-based driver? And why so?

I have two scenarios:

(1) Java/JDBC application runs on separate (application) server to the database server. For example, Windows App Server with Java/JDBC and Oracle 11g R2 database server on Linux. This is similar to N-tier on-line application concept.

(2) Java/JDBC application runs on the same physical server where the database software is located, i.e. both the Java/JDBC and Oracle database run on Linux OS. This is similar to batch job concept.

Many thanks in advance
Yuri B
Melbourne
Australia

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2013

Added on Dec 4 2012

#11g, #database, #database-connectivity-discussions, #jdbc, #oci, #oracle, #performance

5 comments

3,925 views