Database

Get Involved. Join the Conversation.

Topic

    Karthik Varma
    [Compatibility] Do ojdbc8.jar supports connectivity to...Answered
    Topic posted November 14, 2019 by Karthik VarmaGold Medal: 3,500+ Points, last edited November 14, 2019, tagged Monitoring, Tip 
    20 Views, 3 Comments
    Title:
    [Compatibility] Do ojdbc8.jar supports connectivity to Oracle 12c, 11g & 10g databases?
    Content:

    Using ojdbc8.jar we connect to autonomous databases. Will it provides backward compatibility to older versions?

    Best Comment

    Simon Law

    Short answer: Yes, with Oracle Database 12c and 11g but not 10g.

    Longer version: See the answers for What are the Oracle JDBC releases Vs JDK versions? and What is the JDBC and RDBMS interoperability matrix or the certification matrix? in the JDBC FAQ.

    ojdbc8.jar starting shipping with 12cR2, the text below is from the Backward Compatibility section in the 12cR2 JDBC Developer's Guide.

    Oracle Database 12c Release 2 (12.2.0.1) JDBC drivers are certified with supported Oracle Database releases (11.x.0.x). However, they are not certified to work with older, unsupported database releases, such as 10.2.x, 10.1.x, 9.2.x, and 9.0.1.x.

    Comment

     

    • Simon Law

      Short answer: Yes, with Oracle Database 12c and 11g but not 10g.

      Longer version: See the answers for What are the Oracle JDBC releases Vs JDK versions? and What is the JDBC and RDBMS interoperability matrix or the certification matrix? in the JDBC FAQ.

      ojdbc8.jar starting shipping with 12cR2, the text below is from the Backward Compatibility section in the 12cR2 JDBC Developer's Guide.

      Oracle Database 12c Release 2 (12.2.0.1) JDBC drivers are certified with supported Oracle Database releases (11.x.0.x). However, they are not certified to work with older, unsupported database releases, such as 10.2.x, 10.1.x, 9.2.x, and 9.0.1.x.

      • Karthik Varma

        Thanks for the quick response.

        With ojdbc8.jar, can we connect to 19c database? or new jar has to be used?

        • Simon Law

          Yes, 19c database is supported. This is listed in the "What is the JDBC and RDBMS interoperability matrix or the certification matrix?" in the JDBC FAQ.