Missing artifact com.oracle:ojdbc6:jar:11.2.0 in pom.xml

Question

Missing artifact com.oracle in pom.xml

I am using Eclipse Luna and working on a maven project. When I add the entry for ojdbc jar in pom.xml , it is giving error in the xml. I can't find any reason for the issue as groupId, artifactId and version are correct.

How can I fix the problem?

Have you manually added this jar to your local repo or specified a repo that contains it? — Beau Grantham, Aug 04 '14 at 21:58
Possible duplicate of [Find Oracle JDBC driver in Maven repository](http://stackoverflow.com/questions/1074869/find-oracle-jdbc-driver-in-maven-repository) — zloster, Apr 18 '17 at 07:56

user3487063 · Accepted Answer · 2018-02-09T15:39:31.353

72

Due to Oracle license restriction, there are no public repositories that provide ojdbc jar.

You need to download it and install in your local repository. Get jar from Oracle and install it in your local maven repository using

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

If you are using ojdbc7, here is the link

edited Feb 09 '18 at 15:39

answered Aug 04 '14 at 22:00

user3487063

3,672
1
17
24

Also visit [http://stackoverflow.com/questions/9898499/oracle-jdbc-ojdbc6-jar-as-a-maven-dependency] for complete discussion on this topic – Jess Nov 23 '16 at 17:20
i placed the jar in the bin folder and ran this script: mvn install:install-file -Dfile=ojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.1.0.7.0 -Dpackaging=jar – Ryan Augustine Oct 16 '18 at 12:06

score 11 · Answer 2 · edited Apr 18 '17 at 07:49

11

This is the quickest way to solve the problem but it's not recommended because its applicable only for your local system.

Download the jar, comment your previous entry for ojdbc6, and give a new local entry like so:

Previous Entry:

<!-- OJDBC6 Dependency -->
        <!-- <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>1.0</version>
            <scope>runtime</scope>
        </dependency> -->

New Entry:

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

edited Apr 18 '17 at 07:49

Anil Agrawal

2,748
1
24
31

answered Apr 18 '17 at 07:25

Srishti Sinha

618
1
11
23

What's this {project.basedir}? Checked the project location folder but couldn't find the lib folder as in "{project.basedir}/lib/". Can you help me locate it appropriately? – Kailas Jun 20 '17 at 14:10
@Kailas You need to download ojdbc6 jar from internet. This file location is anywhere in your system where you have put the jar. It is not present already. You decide the location. – Srishti Sinha Jun 22 '17 at 06:55

score 4 · Answer 3 · answered Apr 24 '18 at 11:04

Place ojdbc6.jar in your project resources folder of eclipse. then add the following dependency code in your pom.xml

<dependency>
<groupId> oracle </groupId>
 <artifactId>ojdbc6</artifactId>
 <version>11.2.0</version>
  <scope>system</scope>
  <systemPath>${project.basedir}/src/main/resources/ojdbc6.jar</systemPath>
</dependency>

score 2 · Answer 4 · answered Jan 18 '17 at 10:35

Download the oracle ojdbc driver from Oracle official website.

Install/Add Oracle driver to the local maven repository mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc7 -Dpackaging=jar -Dversion=12.1.0.1 -Dfile=ojdbc7.jar -DgeneratePom=true

Specify the downloaded file location via -Dfile=

Add the following dependency in your pom file

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

Use the same groupId/artifactId as specified in your mvn install command. Finally clean your project.

score 2 · Answer 5 · answered Apr 11 '19 at 11:48

You might have problem on Windows while adding jar to maven because of syntax.

Try encapsulating -D parameters with double quotas like this;

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

Be aware of you should use same version/atifactId/groupId inside your pom.xml. You can't use version 11.2.0.3 after command above. You have to put his in you pom.xml;

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

If you want to use another version, like 12.1.0.1, you should run above command with that version or other info

score 2 · Answer 6 · answered Jul 31 '20 at 08:23

I had the same issue. Jenkins's build was falling because of this error..after long hours troubleshooting.

Link to download ojdbc as per your requirement - https://www.oracle.com/database/technologies/maven-central-guide.html

I have downloaded in my maven/bin location and executed the below command.

mvn install:install-file -Dfile=ojdbc8-12.2.0.1.jar -DgroupId=com.oracle -DartifactId=ojdbc8 -Dversion=12.2.0.1 -Dpackaging=jar

POM.xml

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

Feel free to add your comments – Abhinay Gupta Jul 31 '20 at 08:24 — Abhinay Gupta, Jul 31 '20 at 08:24

score 1 · Answer 7 · answered Jul 05 '18 at 07:34

1

Add this is work for me

<repositories>
    <!-- Repository for ORACLE JDBC Driver -->
    <repository>
        <id>codelds</id>
        <url>https://code.lds.org/nexus/content/groups/main-repo</url>
    </repository>
</repositories>

answered Jul 05 '18 at 07:34

quangkid

1,287
1
12
31

score 0 · Answer 8 · answered Feb 14 '19 at 16:29

It's due to the missing of ojdbc6.jar in the maven repository. download it Click Here

Add the dependency in the pom.xml file

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

Install/Add Oracle driver to the local maven repository using the following command in command prompt.

open command prompt
change directory to the apache-maven/bin folder Eg: cd C:\Users\Public\Documents\apache-maven-3.5.2\bin
type the command

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

Eg: mvn install:install-file -Dfile=C://Users//Codemaker//Downloads//Compressed//ojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0 -Dpackaging=jar

NB: use double back slash to seperate folders (//)

score 0 · Answer 9 · edited Dec 25 '19 at 20:08

0

You need to check your config file if it has correct values such as systempath and artifact Id.

    <dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>1.0</version>
    <scope>system</scope>
    <systemPath>C:\Users\Akshay\Downloads\ojdbc6.jar</systemPath>
    </dependency>

edited Dec 25 '19 at 20:08

Rohan Rao

2,505
3
19
39

answered Dec 25 '19 at 15:06

akshay kenjale

19

1

Please add some explanation to your answer as to why is it relevant to OP's answer. – Rohan Rao Dec 25 '19 at 15:17
As i had same issue and i resolve it by providing proper system path of jar file then issue resolved. – akshay kenjale Jan 15 '20 at 05:55

score 0 · Answer 10 · answered Apr 12 '23 at 10:00

0

Sometimes even though the jar is available in the folder the error will not go way to overcome this just change a group id to a meaningful one.

answered Apr 12 '23 at 10:00

Ajay Takur

6,079
5
39
55

score -1 · Answer 11 · answered Jul 19 '17 at 17:12

-1

try this one

    <dependency>
        <groupId>com.hynnet</groupId>
        <artifactId>oracle-driver-ojdbc6</artifactId>
        <version>12.1.0.1</version>
    </dependency>

answered Jul 19 '17 at 17:12

janakinaidu

7
1

Still getting error Failure to find com.hynnet:oracle-driver-ojdbc6:jar:12.1.0.1 in https://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 - – Saurabh Verma Oct 15 '19 at 10:19

score -3 · Answer 12 · answered Nov 23 '20 at 07:18

-3

oracle driver. `

<dependency>
    <groupId>com.hynnet</groupId>
    <artifactId>jdbc-fo</artifactId>
    <version>12.1.0.2</version>
</dependency>

`

answered Nov 23 '20 at 07:18

hynnet

1

Missing artifact com.oracle:ojdbc6:jar:11.2.0 in pom.xml

12 Answers12