Page 1 of 1

Oracle DB connection problem using Maven

Posted: Mon Dec 17, 2012 7:05 am
by sunily
Hello,
I have tried to configure "Broadleaf" with mySql database and connection created successfully.But while trying to connect to oracle I am getting the following error message:--
"Missing artifact com.oracle:com.springsource.oracle.jdbc:jar:10.2.0.2"

Here is the code in my pom.xml.

<dependency>
<groupId>com.oracle</groupId>
<artifactId>com.springsource.oracle.jdbc</artifactId>
<version>10.2.0.2</version>
<type>jar</type>
<scope>compile</scope>
</dependency>

please provide your inputs, I am stuck at this point.

Regards
Sunil Yadav

Re: Oracle DB connection problem using Maven

Posted: Fri Dec 21, 2012 11:47 am
by phillipuniverse
Maybe your dependency is declared incorrectly. That error just means that it cannot find that dependency in maven central.

Re: Oracle DB connection problem using Maven

Posted: Thu Jun 04, 2015 12:11 am
by rudy
1. Firstly, you need to correct your <artifactId>

Code: Select all

<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>10.2.0.2</version>
<type>jar</type>
<scope>compile</scope>
</dependency>


2. You need to register your oracle JDBC driver jar with maven.
Try the following command

Code: Select all

mvn install:install-file -Dfile=<path_to_driver_jar>ojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=10.2.0 -Dpackaging=jar


3. And then, right click on your maven project -> Maven -> Update Project
OR
you can simply click on your maven project and Press [ALT + F5]