Oracle JDBC ojdbc6 Jar as a Maven Dependency

Question

I cannot seem to get Maven to bundle the ojdbc6 jar file into my project s war file   I have it working within the POM file when specifying a dependency directly for Hibernate tools   But it won t get bundled with the project s war file  and therefore my project won t run on Tomcat   I have tried every solution I can find out there on the net  including those specified for this question here   Find Oracle JDBC driver in Maven repository  Most recently  I did the following    Download the jar file to my machine Run the following command to install the jar into my local repository   mvn install install-file -DgroupId com oracle -DartifactId ojdbc6 -Dversion 11 2 0 3 -Dpackaging jar -Dfile ojdbc6 jar -DgeneratePom true    I ve tried all kinds of variants of that command  too   Finally  I put the dependency into my pom file    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   I run a clean build  but it fails   mvn -U clean package   INFO  Scanning for projects     INFO                                                                            INFO  ------------------------------------------------------------------------  INFO  Building jazztwo 0 0 1  INFO  ------------------------------------------------------------------------ Downloading  http   repo1 maven org maven2 com oracle ojdbc6 11 2 0 3 ojdbc6-11 2 0 3 jar  INFO  ------------------------------------------------------------------------  INFO  BUILD FAILURE  INFO  ------------------------------------------------------------------------  INFO  Total time  0 700s  INFO  Finished at  Tue Mar 27 15 06 14 PDT 2012  INFO  Final Memory  3M 81M  INFO  ------------------------------------------------------------------------  ERROR  Failed to execute goal on project jazztwo  Could not resolve dependencies for project edu berkeley jazztwo war 0 0 1  Could not find artifact com oracle ojdbc6 jar 11 2 0 3 in central  http   repo1 maven org maven2  - gt   Help 1     Why doesn t this work   I m ready to throw expensive computer parts across the room   This has wasted so much time   Thank you  Oracle   How much did we pay you again      Is it because I m on a Mac  perhaps

User · Answer

Below config worked for me  Refer this link for more details    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

User · Answer

I followed below command it worked   mvn install install-file -Dfile E  JAVA Spring ojdbc14-10 2 0 4 0 jar ojdbc14-10 2 0 4 0 jar -DgroupId com oracle -DartifactId ojdbc14 -Dversion 10 2 0 4 0 -Dpackaging jar   After installation check that jar is installed correctly on your M2 repo

User · Answer

After executing  mvn install install-file -DgroupId com oracle -DartifactId ojdbc6 -Dversion 11 2 0 3 -Dpackaging jar -Dfile ojdbc6 jar -DgeneratePom true   check your  m2 repository folder   com oracle ojdbc6 11 2 0 3  to see if ojdbc6 jar exists  If not check your maven repository settings under  M2 HOME conf settings xml

User · Answer

Go to the C drive- user- PcName- find  m2 and Paste the downloaded ojdbc jar file there  Server will automatically pick this

User · Answer

The correct answer was supplied by Raghuram in the comments section to my original question   For whatever reason  pointing  mvn install  to a full path of the physical ojdbc6 jar file didn t work for me    Or I consistently repeatedly flubbed it up when running the command  but  no errors were issued    cd-ing into the directory where I keep ojdb6 jar and running the command from there worked the first time   If Raghuram would like to answer this question  I ll accept his answer instead   Thanks everyone

User · Answer

Public  https   mvnrepository com artifact com oracle database jdbc ojdbc6 11 2 0 4  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

User · Answer

Oracle JDBC drivers and other companion Jars are available on Central Maven  We suggest to use the official supported Oracle JDBC versions from 11 2 0 4  12 2 0 2  18 3 0 0  19 3 0 0  19 6 0 0  and 19 7 0 0  These are available on Central Maven Repository  Refer to Maven Central Guide for more details  It is recommended to use the latest version  Check out FAQ for JDK compatibility

User · Answer

mvn install install-file  -Dfile C  Users xxxx Downloads lib ojdbc6 jar  -DgroupId com oracle -DartifactId ojdbc6 -Dversion 11 2 0 -Dpackaging jar   to resolve the ORACLE JAR issue with the Spring Application   Oracle JDBC ojdbc6 Jar as a Maven Dependency       lt dependency 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  dependency gt

User · Answer

I have tried using the dependency without version tag and its worked fine for me   lt dependency gt       lt groupId gt com oracle ojdbc lt  groupId gt       lt artifactId gt ojdbc8 lt  artifactId gt   lt  dependency gt

User · Answer

For anyone reading this post in the future  you don t need to cd to the directory where the jar is present  Here is what you need to do -  Go to your project folder from where you can run maven commands  When you do an ls -ltr in this folder  you should see pom xml   Do this -  mvn install install-file -DgroupId com oracle -DartifactId ojdbc6 -Dversion 11 2 0 3 -Dpackaging jar -Dfile  lt Path where the jar is  example downloads gt  ojdbc6 jar -DgeneratePom true   Once this is done  you can add the dependency in your pom xml  something like this -       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

User · Answer

It is better to add new Maven repository  preferably using your own artifactory  to your project instead of installing it to your local repository   Maven syntax    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 repositories 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    Grails example    mavenRepo  https   code lds org nexus content groups main-repo  build  com oracle ojdbc6 11 2 0 3

User · Answer

First you need to download the particular jar from Oracle site  ojdbc jar version 11 2 0 3    if you download it to C  filefolder  go to that directory in cmd prompt and provide the below command It will install the dependency Then you can build your project   mvn install install-file -DgroupId com oracle -DartifactId ojdbc6 -Dpackaging jar -Dversion 11 2 0 4 0 -Dfile ojdbc6 jar -DgeneratePom true

User · Answer

Since Oracle is the licensed product  there are issue in adding maven dependency directly  To add any version of the ojdbc jar  below 2 steps could do    Run the below command to install ojdbc jar into local maven repository     opt apache-maven bin mvn install install-file     -Dfile  lt path-to-file gt  ojdbc7 jar     -DgroupId com oracle     -DartifactId ojdbc7     -Dversion 12 1 0 1 0     -Dpackaging jar   This will add the dependency into local repository    Now  add the dependency in the pom file    lt dependency gt       lt groupId gt com oracle lt  groupId gt       lt artifactId gt ojdbc7 lt  artifactId gt       lt version gt 12 1 0 1 0 lt  version gt   lt  dependency gt

User · Answer

Add Following dependency in pom xml   lt dependency gt       lt groupId gt com oracle lt  groupId gt       lt artifactId gt oracle lt  artifactId gt       lt version gt 10 2 0 2 0 lt  version gt   lt  dependency gt

[oracle] Oracle JDBC ojdbc6 Jar as a Maven Dependency

Examples related to oracle

Examples related to maven

Examples related to jdbc

Examples related to war