Find jdbc driver in Maven repository

Question

Hi,

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:

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc14</artifactId>
    <version>10.2.0.3.0</version>
</dependency>

of course this does't work as it is not in the central repository used by maven. 2 questions:

1) How do I find a repository (if any) that contains this artifact?

2) How do I add it so that Maven will use it?

Thaks,

Ronen.

Answer 1

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 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:

mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc14 \
     -Dversion=10.2.0.3.0 -Dpackaging=jar -Dfile=ojdbc.jar

If your team has a local Maven repository this guide might be helpful to upload the JAR there

Answer 2

This worked for me:

    <dependency> 
        <groupId>oracle</groupId> 
        <artifactId>jdbc</artifactId> 
        <version>6</version> 
    </dependency>