Missing artifact com.oracle:ojdbc6:jar:11.2.0.3

Question

I am a beginner to Maven project. In my project, I am getting the error Missing artifact com.oracle:ojdbc6:jar:11.2.0.3, even though the jar was present in my repository at the correct folder. Can anyone help with this, please?

Answer 1

Unfortunately, due to the binary license, there is no public repository with the Oracle Driver JAR, so you cannot just add it to your pom file.

You have to add this jar manually:

First, you have to download ojdbc6.jar from here click jar (2.6 MB) on the middle of the page.

Then put ojdbc6.jar in some folder in your project (let's use lib).

Then you have to add this in your dependencies section in your pom.xml:

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc</artifactId>
    <version>11.2.0</version>
    <scope>system</scope>
    <systemPath>${basedir}/lib/ojdbc6.jar</systemPath>
</dependency>

Another option is to install this jar in your local maven repository:

mvn install:install-file -Dfile=path/to/ojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0 -Dpackaging=jar

And then you will be able to reference this dependency like this:

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0</version>
</dependency>

You have to choose what's best for you.

Answer 2

Remove the ojdbc6 folder from the .m2 repository completely and then maven update the project in enclipse that solved my problem