Adding odbc14.jar manually to Spring Roo project

Question

I am getting error as

"Missing artifact com.oracle:ojdbc14:jar:10.2.0.4"

in pom.xml when i entered command,

jpa setup --provider ECLIPSELINK --database ORACLE

I googled and found out that

"oracle jar cannot be added automatically, as of now. we have to configure it manually."

Can i maven dependency related jar manually to project? If yes, How?

see http://stackoverflow.com/questions/9898499/oracle-jdbc-ojdbc6-jar-as-a-maven-dependency — krishnakumarp, Jun 13 '13 at 11:32

score 0 · Answer 1 · answered Sep 29 '13 at 02:12

You'll need to manually install the driver from Oracle.

In command prompt install the driver to Maven's local repository using mvn install:install-file.

> mvn install:install-file -Dfile=your_ojdbc.jar -DgroupId=com.oracle -DartifactId=oracle -Dversion=10.2.0.2.0 -Dpackaging=jar -DgeneratePom=true

Now you add the dependency to the pom.xml

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>oracle</artifactId>
    <version>10.2.0.2.0</version>
</dependency>

1 Answers1