CODEWITHSUNDEEP
javaoracle-databasejdbcdriver
user3198603
user3198603

Reputation: 5826

how to use JDBC 4 driver with oracle 11?

I am using oracle 11g . I do not know what is the default driver comes with oracle 11g. I see ojdbc14-10.2.0.3.0 under my <TOMCAT_HOME>/lib. I am not sure what change i need to do to make sure i am using JDBC 4 driver ?

Do i need to replace ojdbc14-10.2.0.3.0 or i need to put some other jar under my oracle installation ?

Upvotes: 0

Views: 1199

Answers (1)

solar
solar

Reputation: 1364

According to Oracle article, Oracle Database 11g Release 1 (11.1) goes with JDBC drivers provide support for the JDBC 4.0 standard. You should have the ojdbc6.jar in your classpath environment variable in order to have JDBC 4.0 standard support.

Take a look at Oracle's JDBC drivers list: for 11g and 11g2, only ojdbc5.jar and ojdbc6.jar are listed, but some says that ojbc14 should work just fine with Oracle11g. The primary difference between ojbc14 and later versions is that it wouldn't support new JDBC API, so I suppose you should better go with newer drivers.

Upvotes: 2

Related Questions