Find Oracle JDBC driver in Maven repository

Question

I want to add the oracle jdbc driver to my project as dependency  runtime scope  - ojdbc14  In MVNrepository site the dependency to put in the POM is    lt dependency gt       lt groupId gt com oracle lt  groupId gt       lt artifactId gt ojdbc14 lt  artifactId gt       lt version gt 10 2 0 3 0 lt  version gt   lt  dependency gt    of course this does t work as it is not in the central repository used by maven  2 questions    How do I find a repository  if any  that contains this artifact  How do I add it so that Maven will use it

User · Answer

The Oracle JDBC drivers are now available in Maven Central  Here is the Link    Oracle JDBC Drivers - Maven Central  Oracle developers article announcing the availability of the Oracle JDBC drivers in Maven Central   Oracle announcing - Oracle JDBC drivers available in Maven Central  Example    lt  -- https   mvnrepository com artifact com oracle jdbc ojdbc10 -- gt   lt dependency gt      lt groupId gt com oracle database jdbc lt  groupId gt      lt artifactId gt ojdbc10 lt  artifactId gt      lt version gt 19 3 0 0 lt  version gt   lt  dependency gt

User · Answer

For whatever reason  I could not get any of the above solutions to work    Still can t    What I did instead was to include the jar in my project  blech  and then create a  system  dependency for it that indicates the path to the jar   It s probably not the RIGHT way to do it  but it does work   And it eliminates the need for the other developers on the team  or the guy setting up the build server  to put the jar in their local repositories   UPDATE   This solution works for me when I run Hibernate Tools   It does NOT appear to work for building the WAR file  however   It doesn t include the ojdbc6 jar file in the target WAR file   1  Create a directory called  lib  in the root of your project   2  Copy the ojdbc6 jar file there  whatever the jar is called    3  Create a dependency that looks something like this    lt dependency gt       lt groupId gt com oracle lt  groupId gt       lt artifactId gt ojdbc lt  artifactId gt       lt version gt 14 lt  version gt       lt scope gt system lt  scope gt       lt systemPath gt   basedir  lib ojdbc6 jar lt  systemPath gt   lt  -- must match file name -- gt   lt  dependency gt    Ugly  but works for me   To include the files in the war file add the following to your pom   lt build gt       lt finalName gt MyAppName lt  finalName gt       lt plugins gt           lt plugin gt               lt groupId gt org apache maven plugins lt  groupId gt               lt artifactId gt maven-war-plugin lt  artifactId gt               lt configuration gt                   lt webResources gt                       lt resource gt                           lt directory gt   basedir  src main java lt  directory gt                           lt targetPath gt WEB-INF classes lt  targetPath gt                           lt includes gt                               lt include gt      properties lt  include gt                               lt include gt      xml lt  include gt                               lt include gt      css lt  include gt                               lt include gt      html lt  include gt                           lt  includes gt                       lt  resource gt                       lt resource gt                           lt directory gt   basedir  lib lt  directory gt                           lt targetPath gt WEB-INF lib lt  targetPath gt                           lt includes gt                               lt include gt      jar lt  include gt                           lt  includes gt                       lt  resource gt                   lt  webResources gt               lt  configuration gt           lt  plugin gt            lt plugin gt               lt artifactId gt maven-compiler-plugin lt  artifactId gt               lt configuration gt                   lt source gt 1 6 lt  source gt                   lt target gt 1 6 lt  target gt               lt  configuration gt           lt  plugin gt       lt  plugins gt   lt  build gt

User · Answer

You can find a Github simple sample project for use a Oracle JDBC Driver on Maven Project here   You can find all explication for your continous integration   a sample and run on Travis-CI   DEMO

User · Answer

If you are using Netbeans  goto Dependencies and manually install artifact  Locate your downloaded  jar file and its done  clean build will solve any issues

User · Answer

As of today  27  February 2020  Oracle announced that it has published all JDBC client libraries from version 11 2 0 4  e g  ojdbc6  to 19 3 0  e g  ojdbc10  on Maven Central under the group id com oracle database   Example    lt dependency gt     lt groupId gt com oracle database jdbc lt  groupId gt     lt artifactId gt ojdbc10 lt  artifactId gt     lt version gt 19 3 0 0 lt  version gt   lt  dependency gt

User · Answer

SOLVED   Please do following settings to resolve the error   This repository needs to be enable for finding Oracle 10 0 3 0 dependecies  this setting needs to be done in Buildconfig groovy grails project dependency resolver    ivy     or ivy  Also use following setting for compile time Oracle driver download   runtime  com oracle ojdbc 10 2 0 3 0   This should solve your issue for not finding the Oracle driver for grails application

User · Answer

Download the jar and place it in your project src lib  Now you can use the maven installer plugin    lt plugin gt       lt groupId gt org apache maven plugins lt  groupId gt       lt artifactId gt maven-install-plugin lt  artifactId gt       lt version gt 2 3 1 lt  version gt       lt executions gt           lt execution gt               lt id gt install-oracle-jdbc lt  id gt               lt goals gt                   lt goal gt install-file lt  goal gt               lt  goals gt               lt phase gt clean lt  phase gt               lt configuration gt                   lt groupId gt com oracle lt  groupId gt                   lt artifactId gt ojdbc6 lt  artifactId gt                   lt version gt 11 2 0 lt  version gt                   lt packaging gt jar lt  packaging gt                   lt generatePom gt true lt  generatePom gt                   lt createChecksum gt true lt  createChecksum gt                   lt file gt   project basedir  src lib ojdbc6 jar lt  file gt               lt  configuration gt           lt  execution gt       lt  executions gt   lt  plugin gt    Now you only have to execute mvn clean once and the oracle lib is installed in your local maven repository

User · Answer

Oracle is now exposing a maven repository at maven oracle com However you need to be authenticated   See https   blogs oracle com WebLogicServer entry weblogic server and the oracle  According to the comments in the blog post the ojdbc driver should be available at the following coordinates    lt groupId gt com oracle weblogic lt  groupId gt    lt artifactId gt ojdbc7 lt  artifactId gt    lt version gt 12 1 3-0-0 lt  version gt    lt packaging gt jar lt  packaging gt

User · Answer

The Oracle JDBC Driver is now available in the Oracle Maven Repository  not in Central     lt dependency gt       lt groupId gt com oracle jdbc lt  groupId gt       lt artifactId gt ojdbc7 lt  artifactId gt       lt version gt 12 1 0 2 lt  version gt   lt  dependency gt    The Oracle Maven Repository requires a user registration  Instructions can be found in   https   blogs oracle com dev2dev get-oracle-jdbc-drivers-and-ucp-from-oracle-maven-repository-without-ides  Update 2019-10-03  I noticed Spring Boot is now using the Oracle JDBC Driver from Maven Central     lt dependency gt       lt groupId gt com oracle ojdbc lt  groupId gt       lt artifactId gt ojdbc10 lt  artifactId gt       lt version gt 19 3 0 0 lt  version gt   lt  dependency gt    For Gradle users  use   implementation  com oracle ojdbc ojdbc10 19 3 0 0    There is no need for user registration   Update 2020-03-02  Oracle is now publishing the drivers under the com oracle database group id  See Anthony Accioly answer for more information  Thanks Anthony   Oracle JDBC Driver compatible with JDK6  JDK7  and JDK8    lt dependency gt     lt groupId gt com oracle database jdbc lt  groupId gt     lt artifactId gt ojdbc6 lt  artifactId gt     lt version gt 11 2 0 4 lt  version gt   lt  dependency gt    Oracle JDBC Driver compatible with JDK8  JDK9  and JDK11    lt dependency gt     lt groupId gt com oracle database jdbc lt  groupId gt     lt artifactId gt ojdbc8 lt  artifactId gt     lt version gt 19 3 0 0 lt  version gt   lt  dependency gt    Oracle JDBC Driver compatible with JDK10 and JDK11   lt dependency gt     lt groupId gt com oracle database jdbc lt  groupId gt     lt artifactId gt ojdbc10 lt  artifactId gt     lt version gt 19 3 0 0 lt  version gt   lt  dependency gt

User · Answer

Some Oracle Products support publishing maven artifacts to a local repository  The products have a plugin maven directory which contains descriptions where to find those artifacts and where to store them  There is a Plugin from Oracle which will actually do the upload   See  http   docs oracle com middleware 1212 core MAVEN config maven htm  One of the products which may ship OJDBC in this way is the WLS  it uses however quite strange coordinates    lt groupId gt com oracle weblogic lt  groupId gt   lt artifactId gt ojdbc6 lt  artifactId gt   lt version gt 12 1 2-0-0 lt  version gt

User · Answer

I ship opensource under LGPLv2 and even after several email conversations with Oracle they were unclear whether I was allowed to ship their binary JDBC driver with my distribution  The issue related to whether my license was compatible with their OTN terms so they suggested I was not permitted to ship the driver  Presumably related to this part      b  to distribute the programs with applications you have developed to your customers provided that each such licensee agrees to license terms consistent with the terms of this Agreement   So even if you manage to publish the driver legally in your exclusive local maven repository there is still the restriction on what you are permitted to do with that artifact  Seems absurd that even if I ship their driver in binary form along with the full OTN license file I still can t use it and must force my users to manually download the Oracle driver and drop into my library path before they can use my software

User · Answer

There is one repo that provides the jar  In SBT add a resolver similar to this   oracle driver repo  at  http   dist codehaus org mule dependencies maven2   and a dependency   oracle                 ojdbc14                  10 2 0 2   You can do the same with maven  pom xml and jar are available  http   dist codehaus org mule dependencies maven2 oracle ojdbc14 10 2 0 2

User · Answer

Up to now  its not possible to use maven repositories  I m using ivy as dependency management tool  but also use maven2  s ibiblio repositories  And this is working for ivy    lt dependency org  oracle  name  ojdbc14  rev  10 2 0 2  conf   - gt default   gt    Maven2  s dependency could be something like that    lt dependency gt        lt groupId gt oracle lt  groupId gt        lt artifactId gt ojdbc14 lt  artifactId gt        lt version gt 10 2 0 2 lt  version gt    lt  dependency gt    Notice that i define http   download java net maven 2  and http   mirrors ibiblio org pub mirrors maven mule dependencies maven2  organisation   module   revision   artifact - revision   ext  as external maven2 repos on my ivy settings

User · Answer

For dependency   lt dependency gt       lt groupId gt com oracle lt  groupId gt       lt artifactId gt ojdbc7 lt  artifactId gt       lt version gt 12 1 0 2 lt  version gt   lt  dependency gt    Try   lt repository gt       lt id gt mvnrepository lt  id gt       lt url gt http   nexus saas hand-china com content repositories rdc lt  url gt   lt  repository gt

User · Answer

1  How do I find a repository  if any  that contains this artifact   As DavidS has commented the line I quoted at the time I answered is no longer present in the current  at the time I m writing now  OTN License Agreement agreement I linked  Consider this answer only for older version of the artifact  as the 10 2 0 3 0 and the like    All Oracle Database JDBC Drivers are distribuited under the OTN License Agreement   If you read the OTN License Agreement you find this license term      You may not          - distribute the programs unless accompanied with your applications          so that s why you can t find the driver s jar in any public Maven Repository  because it would be distributed alone  and if it happened it would be a license violation   Adding the dependency    lt dependency gt       lt groupId gt com oracle lt  groupId gt       lt artifactId gt ojdbc14 lt  artifactId gt       lt version gt 10 2 0 3 0 lt  version gt   lt  dependency gt     or any later version  make Maven downloads the ojdbc14-10 2 0 3 0 pom only  and in that pom you can read        lt licenses gt       lt license gt           lt name gt Oracle Technology Network Development and Distribution License Terms lt  name gt           lt url gt http   www oracle com technology software htdocs distlic html lt  url gt       lt  license gt   lt  licenses gt        which informs you about the OTN License   2  How do I add it so that Maven will use it   In order to make the above dependency works I agree with victor hugo who were suggesting you here to manually install the jar into your local Maven repository  the  m2 directory  by running   mvn install install-file -Dfile  Path to your ojdbc jar  -DgroupId com oracle  -DartifactId ojdbc -Dversion 10 2 0 3 0 -Dpackaging jar   but I want to add that the license term above doesn t limit only where you can t find the JDBC jar  but it limits where you install it too   In fact your local Maven repository must be private and not shared because if it was shared it would be a kind of distribution in which the jar is distributed alone  even if to a little group of people into your local area network  and this represent a OTN License Agreement violation   Moreover I think you should avoid installing the JDBC jar in your corporation repository manager  such as Artifactory or Nexus  as a single artifact because if it was installed it would be still distributed alone  even if to people in your organization only  and this represents a OTN License Agreement violation

User · Answer

This worked for me like charm  I went through multiple ways but then this helped me  Make sure you follow each step and name the XML files exactly same   https   blogs oracle com dev2dev get-oracle-jdbc-drivers-and-ucp-from-oracle-maven-repository-without-ides  The process is a little tedious but yes it does work

User · Answer

In my case it works for me after adding this below version dependency 10 2 0 4   After adding this version 10 2 0 3 0 it doesn t work due to  jar file not avail in repository path    lt groupId gt com oracle lt  groupId gt   lt artifactId gt ojdbc14 lt  artifactId gt   lt version gt 10 2 0 4 lt  version gt

User · Answer

Good news everyone  Finally we can use Oracle s official repo  https   blogs oracle com dev2dev get-oracle-jdbc-drivers-and-ucp-from-oracle-maven-repository-without-ides

User · Answer

Try with    lt repositories gt       lt  -- Repository for ORACLE ojdbc6  -- gt       lt repository gt           lt id gt codelds lt  id gt           lt url gt https   code lds org nexus content groups main-repo lt  url gt       lt  repository gt   lt  repositories gt   lt dependencies gt        lt dependency gt           lt groupId gt com oracle lt  groupId gt           lt artifactId gt ojdbc6 lt  artifactId gt           lt version gt 11 2 0 3 lt  version gt       lt  dependency gt   lt  dependencies gt

User · Answer

You can use Nexus to manage 3rd party dependencies as well as dependencies in standard maven repositories

User · Answer

Please try below    lt dependency gt       lt groupId gt com oracle ojdbc lt  groupId gt       lt artifactId gt ojdbc8 lt  artifactId gt       lt version gt 19 3 0 0 lt  version gt   lt  dependency gt

User · Answer

How do I find a repository  if any  that contains this artifact   Unfortunately due the binary license there is no public repository with the Oracle Driver JAR  This happens with many dependencies but is not Maven s fault  If you happen to find a public repository containing the JAR you can be sure that is illegal   How do I add it so that Maven will use it   Some JARs that can t be added due to license reasons have a pom entry in the Maven Central repo  Just check it out  it contains the vendor s preferred Maven info    lt groupId gt com oracle lt  groupId gt   lt artifactId gt ojdbc14 lt  artifactId gt   lt version gt 10 2 0 3 0 lt  version gt       and the URL to download the file which in this case is http   www oracle com technology software tech java sqlj jdbc index html   Once you ve downloaded the JAR just add it to your computer repository with  note I pulled the groupId  artifactId and version from the POM    mvn install install-file -DgroupId com oracle -DartifactId ojdbc14        -Dversion 10 2 0 3 0 -Dpackaging jar -Dfile ojdbc jar -DgeneratePom true   The last parameter for generating a POM will save you from pom xml warnings  If your team has a local Maven repository this guide might be helpful to upload the JAR there

[java] Find Oracle JDBC driver in Maven repository

Examples related to java

Examples related to maven

Examples related to jdbc

Examples related to maven-2

Examples related to mvn-repo