Win a copy of Beginning Java 17 Fundamentals: Object-Oriented Programming in Java 17 this week in the Java in General forum!
  • 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:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

Will ojdbc6.jar work with Oracle 19?

 
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello. Will ojdbc6 driver still work with Oracle 19? I've read different things...like existing code will work, you just can't use newer stuff. Thank you.
 
Saloon Keeper
Posts: 24869
174
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Very probably. But why not use a newer Oracle JAR?
 
Thomas Griffith
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks, Tim. I downloaded ojdbc8 and tested and it looks ok in oracle 12 (before they move to oracle 19). I was checking Oracle 21 release and it appears ojdbc8 is good with that one as well. What's weird is that ojdbc10 is listed for oracle 19 and ojdbc11 for oracle 21, but ojdbc8 is also listed for both. Is ojdbc8 a "long-term support" driver or something? thank you again.
 
Tim Holloway
Saloon Keeper
Posts: 24869
174
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am not that closely linked into Oracle to give you a compatibility matrix, but most JDBC drivers these days are "type 4" drivers.

A Type 4 driver is itself written in 100% java and has no binary API connections to the database. It does all its work via network requests, and network requests tend not to change form as much as binary API's do.

For the most part, then, I'd expect an older JDBC driver to work OK with a newer database version. Although you may not get all the vendor improvements that you'd be getting from the newer drivers. Which I'd worry about more except that wherever possible I try NOT to get tied to special features unique to one vendor's products.

Still, for best results (and better support from Oracle!) it's best if you select a database driver that has maximum compatibility with the database release you're working with. JDBC drivers are usually drop-in replacements, so the cost of upgrading is typically minimal.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic