X

Break New Ground

Oracle Database client libraries for Java now on Maven Central

Gerald Venzl
Distinguished Product Manager

Update 2020-08-14: com.oracle.database.soda is now also available on Maven Central!

Oracle has published its Oracle Database JDBC client libraries on Maven Central. From now on you can find Oracle Database related jar files under the com.oracle.database group id. You will find all libraries from version 11.2.0.4 (e.g. ojdbc6) to 19.3.0 (e.g. ojdbc10).

Going forward, Oracle will use Maven Central as one of the primary distribution mechanisms for Oracle Database Java client libraries, meaning that you will also be able to find new versions of these libraries on Maven Central in the future.

To get the latest Oracle Database JDBC driver, use the following dependency GAV in your Maven POM file:

<dependency>
  <groupId>com.oracle.database.jdbc</groupId>
  <artifactId>ojdbc10</artifactId>
  <version>19.3.0.0</version>
</dependency>
The com.oracle.database group id has the following subgroups:
  • com.oracle.database.jdbc: this group contains all JDBC libraries
    • ojdbc[N].jar:
      The Oracle Database JDBC driver compiled with Java [N]
    • ucp.jar:
      The Universal Connection Pool for JDBC
    • ojdbc[N]dms.jar:
      The Oracle Database JDBC driver compiled with Java [N] including the Dynamic Monitoring System (DMS)

      Note: ojdbc8dms.jar and ojdbc10dms.jar contain the instrumentation to support the Dynamic Monitoring System (DMS) and limited support for java.util.logging.
  • com.oracle.database.jdbc.debug: this group contains all JDBC debug libraries
  • com.oracle.database.security: this group contains all Security libraries for Oracle wallet and more
    • oraclepki.jar:
      The Oracle PKI provider used for Oracle wallets
    • osdt_cert.jar:
      Certificate management components used for Oracle wallets
    • osdt_core.jar:
      Core components between oraclepki.jar and osdt_cert.jar
  • com.oracle.database.ha: this group contains all High Availability libraries
    • ons.jar:
      Oracle Notification System library
    • simplefan.jar:
      Simple Fast Application Notification library
  • com.oracle.database.nls: this group contains the Internationalization library
    • orai18n.jar:
      orainternationalization.jar --> orai - 18 letters in between - n.jar
  • com.oracle.database.xml: this group contains all XML and XML DB related libraries
    • xdb.jar, xdb6.jar
      Support for the JDBC 4.x standard java.sql.SQLXML interface
    • xmlparserv2.jar
      The Oracle Database XML Parser library, including APIs for:
      • DOM and Simple API for XML (SAX) parsers
      • XML Schema processor
      • Extensible Stylesheet Language Transformation (XSLT) processor
      • XML compression
      • Java API for XML Processing (JAXP)
      • Utility functionality such as XMLSAXSerializer and asynchronous DOM Builder

        Note: xdb6.jar is a legacy name, xdb.jar is the new name.
  • com.oracle.database.observability: this group contains the Observability library
    • dms.jar:
      The Oracle Database Dynamic Monitoring System (DMS)
  • com.oracle.database.soda: this group contains the Simple Oracle Document Access driver for Oracle Database
  • com.oracle.database.messaging (coming soon!): this group contains the Advanced Queuing Java Messaging Service driver for Oracle Database

With this change, Oracle made it easier than ever before for developers and users alike to consume the Oracle Database Java client libraries.

Join the discussion

Comments ( 18 )
  • Dmitry Brin Friday, February 28, 2020
    A true miracle!
  • Shivankur Pal Friday, February 28, 2020
    Finally...
  • Viivek Friday, February 28, 2020
    Awesome news!
  • Paul Saturday, February 29, 2020
    Holy crap finally. This will make things easier for many developers, especially around patching and getting started.

    Good job fellas
  • BFW Saturday, February 29, 2020
    A bit overdue, but welcome nevertheless.
  • Claudio Weiler Monday, March 9, 2020
    Hi, thanks for the release, but I'm missing ojdbc7!
  • Kuassi Mensah Friday, March 13, 2020
    @Claudio.W,
    In general, we recommend to use the latest drivers; these work against older RDBMS releases n-1, n-2 as well as newer ones n+1, n+2.
    We skipped 12.1 because we choose to post only one major release in the series; iow, 11.2, 12.2, 18.3, 19.3.
    Is this a problem to your environment?
  • Sebastian Peters Saturday, March 14, 2020
    Would it be possible to make all those transitive dependencies "optional" by default? Not every project needs them. Otherwise those dependencies could be excluded on a per project basis. Thank you.
  • Alexandra Telnikoff Sunday, March 15, 2020
    Oracle OLAP client libraries any time soon? Thanks.
  • Kuassi Mensah Tuesday, March 17, 2020
    @Sebastian We are aware of the impact of these dependencies and will take corrective measures as soon as possible; looking into coming up with a BOM file, instead and dropping the transitive dependencies.
  • Alexandra Telnikoff Wednesday, April 1, 2020
    OLAP - please respond. It’s ‘important’. Thanks.
  • Bud Endress Friday, April 3, 2020
    Alexandra, can you clarify what you mean by 'OLAP client libraries'. Thanks.
  • Alexandra Telnikoff Wednesday, April 8, 2020
    OLAP client libraries are needed to connect to Oracle data cube over JDBC. They include:

    olap_api.jar
    awxml.jar
    olap_api_spl.jar
    xmlpatser2.jar

    For example, they are distributed with Oracle SQL Developer & some other tools like that. Very hard to deploy modern applications when these dependencies are not in Maven.

    Thanks
    Alexandra
  • Claudio Weiler Tuesday, April 28, 2020
    @Kuassi,
    Accordingly to oracle jdbc faq (https://www.oracle.com/database/technologies/faq-jdbc.html): for database 12.1 or 12cR1, with JDK 8, we should use ojdbc7.
    Regards compatibility, we have a specific relationship. Maybe oracle faq could be updated?
  • Kuassi Mensah Tuesday, April 28, 2020
    @Claudio

    Exactly, ojdbc7.jar from 12gR1 is compiled with JDK 7 and compatible with JDK 8.

    Cheers.
  • Kuassi Mensah Tuesday, April 28, 2020
    @Alexandra,

    Sorry, not ignoring you but have not been monitoring this blog. The OLAP jars are built by a different team; my team only furnishes the core JDBC driver jars.
    Will follow up with their PM and ask him.her to follow up with you .

    Cheers, Kuassi
  • Gana Natraj Monday, July 27, 2020
    Any update on when Oracle SODA library will get onto maven central?
  • Gerald Venzl Friday, August 14, 2020
    Hi Gana,

    The Oracle SODA library is now on Maven Central as well! :)

    Just head over to https://search.maven.org/search?q=com.oracle.database.soda

    Thanks,
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.