1

Missing artifact com.oracle:ojdbc6:jar:11.1.0.7.0

enter image description here

I am using Spring tool suite IDE for developing spring maven project which is similar ecllipse IDE, I found Solutions for this issue on stackoverflow but it doesn't work for me'. I tried two links:

but still I am getting

Missing artifact com.oracle:ojdbc6:jar:11.1.0.7.0

error in pom.xml, I am now stuck at this point.

James Z
  • 12,209
  • 10
  • 24
  • 44
Chandan Vishwakarma
  • 75
  • 4
  • 11
  • Best solution is to start using a repository manager and install into that repository manager. The simple reason is that Oracle has never deployed jdbc drivers to Maven central.. – khmarbaise Mar 28 '18 at 17:12

1 Answers1

1

its because of ojdbc jar is not available on maven repo. so you have to add this dependency from local relative path 

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

You can download ojdbc jar from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

Ajit Kamble
  • 153
  • 1
  • 12
  • This will not work cause you missed `system` apart of never a good idea of having system scoped dependencies. Better using a repository manager... – khmarbaise Mar 28 '18 at 17:13
  • Furthermore this will produce a [WARNING starting with Maven 3.5.2](http://maven.apache.org/docs/3.5.2/release-notes.html) see [MNG-6207](https://issues.apache.org/jira/browse/MNG-6207). – khmarbaise Mar 28 '18 at 17:26
  • @khmarbaise , Ajit Kamble thanks it works for me, but i have another project I haven't used and tags and their its working fine,I can't understand why, can you have any idea? – Chandan Vishwakarma Apr 02 '18 at 17:15