Oracle JDBC 7 as a dependency on Maven

Question

I am trying to add Oracle JDBC to my project as a maven dependency. I followed several online tutorials that offer various ways to add third party dependencies.

I chose the local installation method, but, like ( this person ), I am having problems.

I run the following command to install jar:

mvn install:install-file -Dfile={lib/ojdbc7.jar} -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1.0.1 -Dpackaging=jar 

and he succeeds:

 [INFO] --- maven-install-plugin:2.3:install-file (default-cli) @ standalone-pom --- [INFO] Installing /home/<myfolder>/{lib/ojdbc7.jar} to /home/<myname>/.m2/repository/com/oracle/ojdbc7/12.1.0.1/ojdbc7-12.1.0.1.jar 

Then I added the following message:

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

but when compiling I get the following:

 [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 0.307s [INFO] Finished at: Sat May 02 20:40:07 NZST 2015 [INFO] Final Memory: 8M/56M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal on project xxx: Could not resolve dependencies for project com.xxx:xxx:jar:1.0-SNAPSHOT: Failure to find com.oracle:ojdbc7:jar:12.1.0.1 in http://repo.maven.apache.org/maven2 was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException 

I played with the -U and -o flags to no avail. I also tried to install the jar using the first cding in the lib directory (as suggested by Raghuram on another issue) without any changes.

Answer 1

Decision

• Manually place this ojdbc7-12.1.0.1.jar file in the local Maven / Cache repository.
• Use the mvn deployment target when you are using third-party JAR files / JAR files of your own in local Maven storage.