Missing artifact com.oracle:ojdbc7 in eclipse

Question

I have imported a Maven Project in Eclipse (EE Developer) and I have in my pom.xml file the following error, “Missing artifact com.oracle:ojdbc7:jar:12.1.0.2″ in this code:

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

I have done so by downloading the ojdbc7.jar and run this command:

mvn install:install-file -Dfile=/Path-to-jar/ojdbc7.jar
-DgroupId=com.oracle 
-DartifactId=ojdbc7 
-Dversion=12.1.0.2 
-Dpackaging=jar 
-DgeneratePom=true

After that, I got as an output BUILD SUCCESS, and if I go to the .m2 folder I see in the com->oracle->ojdbc7 two files called “ojdbc7-12.1.0.1.jar.lastUpdated” and “ojdbc7-12.1.0.1.pom.lastUpdated” but still Eclipse brings me the code into the pom.xml file as an error?!?!?! Can some one help?

Rennold

Appears that jar just plain "might not be available" in public maven repo's. Weird. #1075369 – Impressionable

Answer 1

This artifact version (12.1.0.2) has been removed to an another dependency.

See: https://mvnrepository.com/artifact/com.oracle/ojdbc7

Try to change the new dependency:

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

Damek

it worked. I have issue with following dependency " <version>12.1.0</version> </dependency>", after replacing above, it worked. – Sferics

Answer 2

After successfully running the "mvn install" command right click your Project -> Maven -> Update Project (or Alt+F5).

Hydrometallurgy

If its ojdbc7.jar, add <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc7</artifactId> <version>12.1.0</version></dependency> It worked for me. Rather than 12.1.0.1 put 12.1.0. – Demosthenes

Answer 3

I would get rid of those 2 files manually (lastUpdated) then re-run your install command and finally build your project. Those 2 files have been created by mvn as flags to avoid refetching them for a certain amount of time. They certainly have been created prior to your manual install-file command.

Palmapalmaceous

Still getting "Missing artifact". But Thanks – Rennold

After running install, what do you have in your m2 oracle/odbc7 folder? – Palmapalmaceous

Answer 4

I recommend you to follow the instruction given in this link. "http://javabycode.com/build-tools/maven/add-oracle-jdbc-driver-maven.html"

As per your dependency in pom.xml there should be 4 files generated inside "m2repo\com\oracle\ojdbc7\12.1.0.2" folder.

1. ojdbc7-12.1.0.2.jar
2. ojdbc7-12.1.0.2.jar.lastUpdated
3. ojdbc7-12.1.0.2.pom
4. ojdbc7-12.1.0.2.pom.lastUpdated

But as you are saying you checked for "ojdbc7-12.1.0.1.jar.lastUpdated", that should not be the case. I recommend you to delete your dependency folder and then start from scratch.

Epsomite

Answer 5

Some how the jar is not getting downloaded into the local pc. I opened the maven site https://mvnrepository.com/artifact/com.oracle/ojdbc7/12.1.0.2 and downloaded the required jar and placed it in to the .m2 folder, and the error is gone.

Takamatsu