9

We are upgrading our DB from oracle 10g to 11g.

I hope our current JDK1.6 will support this.

What will be ideal JDBC versions for Oracle 11g ?

Currently we are using ojdbc.14.jar , will it support for 11g ?

Please confirm me

ﾤ ﾡ
  • 5,669
  • 6
  • 43
  • 57
Siva Moorthy
  • 131
  • 1
  • 2
  • 4
  • See http://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html – Mihai8 Jun 19 '15 at 02:14
  • I'm voting to close this question as off-topic because it seems like a question better directed to your appropriate Oracle support contact. – larsks Jun 19 '15 at 02:40
  • 2
    `ojdbc.14.jar` is for Java **1.4** You should use `ojdbc6.jar` with Java **6**.. All your questions are answered in the JDBC FAQ: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html –  Jun 19 '15 at 05:43

2 Answers2

7

According to Oracle FAQ, you should use OJDBC7.jar for java version 8

Blockquote

MaVRoSCy
  • 17,747
  • 15
  • 82
  • 125
0

Are you using Java inside the database? Or are you using Java to execute commands on the database?
If the former, see the product sheet for the Oracle version you're moving to. If the latter, anything older than the driver version that ships with the database should work, including the one you mention.

BUT, and that's a very big BUT, JDK 1.6 is out of support and has been for over a year. ojdbc14.jar is far older still and has been out of support for I think close to a decade.
You should really upgrade to JDK 1.8 (latest patch level is 45 or newer) and the ojdbc version that ships with the Oracle version you're upgrading to (ojdbc6).
Better performance, access to new APIs, security fixes, etc. etc.

jwenting
  • 5,505
  • 2
  • 25
  • 30
  • For Java 8 you should use `ojdbc7.jar` –  Jun 19 '15 at 05:43
  • 1
    @a_horse_with_no_name no, you should use the correct one for your version of Oracle, as the driver may support operations not supported by the TNS Listener if you use a newer one. – jwenting Jun 20 '15 at 20:36