Installing JDBC Drivers in Spring Roo 1.1

Posted by Brian Porter on November 21, 2010

I found this tip for installing JDBC drivers for Spring Roo 1.1:

script install-jdbc-drivers.roo

The script basically runs the following commands if you want to do it individually:

osgi install --url http://repository.springsource.com/maven/bundles/external/javax/transaction/com.springsource.javax.transaction/1.1.0/com.springsource.javax.transaction-1.1.0.jar

osgi install --url http://repository.springsource.com/maven/bundles/external/javax/resource/com.springsource.javax.resource/1.5.0/com.springsource.javax.resource-1.5.0.jar

osgi install --url http://repository.springsource.com/maven/bundles/external/com/oracle/jdbc/com.springsource.oracle.jdbc/10.2.0.2/com.springsource.oracle.jdbc-10.2.0.2.jar

osgi install --url http://spring-roo-repository.springsource.org/release/org/springframework/roo/wrapping/org.springframework.roo.wrapping.hsqldb/1.8.0.10.0001/org.springframework.roo.wrapping.hsqldb-1.8.0.10.0001.jar

osgi install --url http://repo1.maven.org/maven2/com/h2database/h2/1.2.144/h2-1.2.144.jar

osgi install --url http://spring-roo-repository.springsource.org/release/org/springframework/roo/wrapping/org.springframework.roo.wrapping.jtopen/6.7.0.0001/org.springframework.roo.wrapping.jtopen-6.7.0.0001.jar

osgi install --url http://spring-roo-repository.springsource.org/release/org/springframework/roo/wrapping/org.springframework.roo.wrapping.jtds/1.2.4.0001/org.springframework.roo.wrapping.jtds-1.2.4.0001.jar

osgi install --url http://repo1.maven.org/maven2/org/apache/derby/derby/10.6.2.1/derby-10.6.2.1.jar

Afterwards, I had to add the Oracle JDBC File to my project (since I wanted to use the Oracle driver):

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

If you made it this far, you may as well follow me on LinkedIn: Follow Brian Porter