• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

JDBC driver

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Morning can someone tell me which JDBC driver is best for connection with Oracle 10G, Java 1.7.
Thanks.
 
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to the Ranch!

Our Oracle FAQ page contains link to the Oracle page containing a list of driver files of different database versions. It also contains a link to driver compatibility matrix, though that page is unfortunately clearly outdated, as it doesn't contain any information on the Oracle 12 JDBC driver.

I'd suggest to use the either the ojdbc6.jar file that comes with the Oracle 11g Release 2 database (it will work with Java 7), or the Java 7 driver was released with the 12c version of the database (ojdbc7.jar). I honestly believe that the 12c version of the driver is backwards compatible with Oracle 10g (Oracle's policy for years was that drivers and databases are mutually compatible if they are two versions apart, if not more), but I haven't found it stated explicitly anywhere yet.
 
When all four tires fall off your canoe, how many tiny ads does it take to build a doghouse?
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic