oracle

[eortizto]

hi im new to roo

i created a project in roo an i use
install jpa -provider HIBERNATE -database ORACLE

when i tried to deploy in maven it says than the oracle driver is missing , i installed the oracle driver in maven but when i tried to compile it keeps saying that the oracle driver is missing , should i change anithing in pom.xml or in roo in order to compile it

thanks

[raul.arabaolaza]

Hi,

Have you tried to add the driver in the pom.xml as a project´s dependency??

I think you will also have to modify the database.properties file

Regards

[tnabil]

Isn't that something that Roo should do automatically? I understand it does that if we choose Hypersonic (at least per the wedding tutorial).

[Ben Alex]

The following fragment from Roo's dependencies.xml shows the dependency configuration for each --database:

	<databases>
		<database id="HYPERSONIC">
			<dependency org="org.hsqldb" name="com.springsource.org.hsqldb" rev="1.8.0.9" />
		</database>
		<database id="POSTGRES">
			<dependency org="org.postgresql" name="com.springsource.org.postgresql.jdbc4" rev="8.3.604" />
		</database>
		<database id="MYSQL">
			<dependency org="com.mysql.jdbc" name="com.springsource.com.mysql.jdbc" rev="5.1.6" />
		</database>
		<database id="H2">
			<dependency org="com.h2database" name="com.springsource.org.h2" rev="1.0.71" />
		</database>
		<database id="MSSQL">
			<dependency  org="net.sourceforge.jtds" name="com.springsource.net.sourceforge.jtds" rev="1.2.2" />
		</database>
		<database id="SYBASE">
			<dependency org="net.sourceforge.jtds" name="com.springsource.net.sourceforge.jtds" rev="1.2.2" />
		</database>
	</databases>

If you know of a specific dependency that can/should be used for Oracle, please feel free to log it into Jira. We'd prefer the dependency by available from a public Maven repository somewhere, but failing that if we know the precise group ID, artifact ID and version that applies to Oracle in private repositories, we can still configure that as the default in the POM.

[tnabil]

Thanks, Ben, for your response.

As a matter of fact, while trying to resolve this problem, I came across posts in other forums which clearly stated that, for licensing reasons, Oracle JAR files can not be hosted on public repositories - special thanks to Oracle for that.

I had to go through the painful exercise of locating the JAR files online, inventing a group, artifact id and version, installing them in my own repository, and configuring them as a dependency.

For others who might read this later, both ojdbc14.jar and dms.jar are required.

[skdskdskd]

where should i down load dms.jar

[krimple]

Thanks, Ben, for your response.
For others who might read this later, both ojdbc14.jar and dms.jar are required.

You can download Oracle's driver from technet.oracle.com

You only need dms.jar if you want to use Oracle's profiling, right? I've used Roo with Oracle and only needed ojdbc14.jar.

FYI, to install the JAR file for your machine, just follow the instructions from Maven - you'll get the error when you do a mvn install:

mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc14 -Dversion=10.2.0.2 -Dpackaging=jar -Dfile=/path/to/file

(This puts the oracle jdbc driver in your maven repo locally, i.e. ~/.m2/repository)

It is annoying, but really an Oracle licensing issue. In enterprises that have artifactory or nexus repositories, they generally add this as one of their first locally managed dependencies.