Oracle db

[BruceBGordon]

For persistence I first used

persistence setup --provider HIBERNATE --database HYPERSONIC_IN_MEMORY

I then (later on the same project) entered

persistence setup  --provider HIBERNATE --database ORACLE

Roo then creating the following POM dependency

<dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc14</artifactId>
            <version>10.2.0.2</version>
        </dependency>

Is the Oracle version is hard coded to 10.2.0.2? (If not where can I adjust it?) If so and if it doesn't match our version then the POM has to be edited. Wouldn't it be better to have some parameters on the persisence setup to direct Roo to use the correct version?

[Stefan Schmidt]

We have chosen the current up-to-date version of the Oracle driver. If you need a different version please change this in the pom.xml file which should be easy. There are also the dependency add and dependency remove commands which can assist you.

HTH,
Stefan

[Alan Stewart]

If you are using 11g, update your dependency accordingly

[xgrigoriadis]

If you are using 11g, update your dependency accordingly

Hi, after I had tested Roo+Oracle back in March this year, and having posted my experiences in this forum and in Jira, I now am still confronted with the same problems, which I could not solve this time. Last time it has just been about correcting the jdbc-url in database.properties and about modifying the Oracle jdbc dependency in pom.xml. This time the same changes seem not to suffice. Even with these two manipulations/corrections I get:

"The ORACLE JDBC driver is not available in public maven repositories. Please adjust the pom.xml dependency to suit your needs."

To be concrete: I have replaced the dependency with the one found in the spring bundle repository.

I am using 11g, but be sure, this cannot be the problem, the 10g jdbc drivers are compatible with 11g, this is tested in many projects I am involved with.

It is very pitty, that such a petty issue, seems to slow down so many people who want to evaluate Roo with Oracle and regularly come and write in this forum about what seems to be the same issue again and again. So please, write down a step-by-step tutorial, about successfully connecting Roo to Oracle.

If there is a thread here, containing such a "tutorial" please point me to it, I have just not found one.

Thanks in advance,

Xenofon

P.S. I very much am excited about Roo and am eager to use it for Oracle based projects

[Alan Stewart]

It would be a simple matter for me to change the dependency to

		<dependency>
			<groupId>com.oracle.jdbc</groupId>
			<artifactId>com.springsource.oracle.jdbc</artifactId>
			<version>10.2.0.2</version>
		</dependency>

So that you don't have to run the mvn install command to place the jar from your Oracle distribution into your maven repo

If a user wanted a different Oracle driver such as a specific 11g version, then they could replace their dependency with the version of their choice. At least, the above dependency would be downloaded automatically.

Raise a Jira improvement request
Alan

[xgrigoriadis]

As I have tried to describe, just changing the dependency in pom.xml did not help this time.
Concerning mvn install. Do you mean to say, Roo+Oracle will only work properly if I setup my own repository?...