CODEWITHSUNDEEP
oracle-databasejdbc
cgon
cgon

Reputation: 1981

Oracle product version and jdbc driver version?

I am using oracle db and the RDBMS product version is : DatabaseProductVersion: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

If I connect this db instance with an older but supported jdbc driver version say 10.1, will there be any performance problems (say 5000 transactions per second)?

Is it a best practice that the product version and jdbc version should match ?

I could not find a satisfying document related with this issue. So I wanted to ask it to the big guys thanks.

Upvotes: 2

Views: 1560

Answers (1)

Appleman1234
Appleman1234

Reputation: 16086

Documentation from Oracle is located at

You have two questions, the first is will you have any performance problems because of using the older JDBC driver ?

The second is should the version of the JDBC driver match the version of the database as a best practice.

I don't know your workload, but any performance problems regarding using the JDBC driver with be related to how you use it more than its specific version. Answering the question of how to do I use Oracle's JDBC drivers in an optimal performing way is a seperate question which depends on your workload.

For documentation regarding that see Java Programming with Oracle JDBC Chapter 19 which gives an example of how the features and which client (OCI or Thin) you use has more impact on performance than JDBC driver version.

Also see High-Performance Oracle JDBC Programming and Expert Oracle JDBC Programming for more information that demonstrates that how you use the features in the driver for performance should influence which JDBC standard you need to use and which driver version supports that standard.

Regarding the second question, the number 5 worst practice is listed as 5. Do not use old versions of the drivers – the 10gR2 drivers are supported with the 8i database!! at Worst practices when using Oracle JDBC Drivers – great presentation by Douglas Surber. Douglas Surber is listed as the principal developer for Oracle JDBC Drivers.

Which leads me to believe the best practice is always using the latest JDBC version that supports your database, unless you have specific issues preventing you from doing so however if you really need official evidence and in person verification of this rather than my word for it, feel free to contact Douglas Surber.

A related SO question is Oracle JDBC driver version madness.

Upvotes: 4

Related Questions