This forum is now a read-only archive. All commenting, posting, registration services have been turned off. Those needing community support and/or wanting to ask questions should refer to the Tag/Forum map, and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor.

Comment

I've only tested with Oracle XE as we don't have an Oracle license for a full version of 10g or 11g. I would appreciate it if you can send me a simple Roo project with an Oracle DDL to stewarta at vmware dot com and I will try to run it.
Thanks

Comment

I did successfully add the jar, manually, to my local repository for Oracle 11g. I had a successful test by creating a simple entity with a single field and was able to create an entry in the database via the web app.

However, when attempting "database reverse engineer" or "database introspect" I receive the following error inside the roo command line app:

No Spring Roo add-ons were found that offer a similar JDBC driver
JDBC driver not available for 'oracle.jdbc.OracleDriver'

It looks like the classpath used by the roo app also needs to have the Oracle driver added somehow? I am not sure if this is the case, or how to approach it.

As a workaround how would I go about leveraging the composite key functionality without reverse engineering a table. I can perform the old method of introspection by manually creating the entities.

Comment

My apologies as I have just realised that the oracle jar and its dependencies need to be in the Roo bundle directory. Please copy com.springsource.oracle.jdbc-10.2.0.2.jar, com.springsource.javax.transaction-1.1.0.jar, and com.springsource.javax.resource-1.5.0.jar to the Roo distribution's bundle directory. Restart Roo and you should be set to go.

We don't package Oracle as the jdbc driver jar is too large. The schema names in Oracle are case sensitive, so when I executed the following command: