Are the latest Oracle 12c Release 2 JDBC driver and UCP available via maven?

Dallas picture Dallas · Mar 19, 2017 · Viewed 14.3k times · Source

Oracle corporation released a new version 12.2.0.1 of their JDBC driver, for Oracle Database 12c Release 2.

The JAR files can be manually downloaded from this location: http://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122-3110062.html

But are these JAR files available through the Oracle Maven repository at maven.oracle.com?

I setup my build originally following this Oracle Blog: Get Oracle JDBC drivers and UCP from Oracle Maven Repository (without IDEs) and have the ojdbc7.jar and ucp.jar as dependency

<dependency>
  <groupId>com.oracle.jdbc</groupId>
  <artifactId>ojdbc7</artifactId>
  <version>12.1.0.2</version>
</dependency>
<dependency>
  <groupId>com.oracle.jdbc</groupId>
  <artifactId>ucp</artifactId>
  <version>12.1.0.2</version>
</dependency>

Now I want to upgrade to the new ojdbc8.jar and latest ucp.jar but don't know the coordinates (and maven.oracle.com does not provide browsing). I could not resolve "com.oracle.jdbc:ojdbc8:12.2.0.1" or "com.oracle.jdbc:ucp:12.2.0.1".

Answer

Nirmala picture Nirmala · Apr 17, 2017

12.2.0.1 JDBC driver and UCP are available on Oracle Maven Repository. You can use the GAV details below to download the same.

<dependency> 
  <groupId>com.oracle.jdbc</groupId>
  <artifactId>ojdbc8</artifactId>
  <version>12.2.0.1</version> 
</dependency>

 <dependency> 
   <groupId>com.oracle.jdbc</groupId>
   <artifactId>ucp</artifactId>
   <version>12.2.0.1</version> 
 </dependency>