This post is not really Bluebell oriented (by now), however I'm interested on sharing it.

As you know Oracle artifacts will not be maintained any more by Spring guys:

• https://jira.springframework.org/browse/ROO-1935

So we need to create an OSGI compliance artifact ourselves:

• https://jira.springframework.org/browse/ROO-1937

Find bellow steps to do it:

1. Download the Oracle artifact you are interested in and materialize it as a Maven artifact. Following links may be interesting for you:
   • http://maven.apache.org/plugins/maven-install-plugin/install-file-mojo.htmlMaven install plugin
   • http://www.oracle.com/technetwork/database/features/jdbc/index-091264.htmlOracle drivers download page
2. Create a new folder in you preferred location and start roo on it.
3. Install gpg and create a public key according to these links (note pgp must be on OS path):
   • http://www.gnupg.org/
   • https://docs.sonatype.org/display/Repository/How+To+Generate+PGP+Signatures+With+Maven
4. Then create the OSGI bundle with the following order:

   • addon create wrapper --topLevelPackage org.bluebell --projectName spring-roo-oracle-wrapper --artifactId ojdbc14 --groupId com.oracle --version classes12 --description "Oracle #jdbcdriver,driverclass:oracle.jdbc.OracleDriver" --licenseUrl "http://www.oracle.com/technetwork/licenses/distribution-license-152002.html" --vendorName "Oracle"
     

5. This is not enough. Additional dependences are required. So edit the recently created pom and add the following repositories and dependencies:

   •  <repositories>
      <repository>
      <id>com.springsource.repository.bundles.release</id>
      <name>SpringSource Enterprise Bundle Repository - SpringSource Bundle Releases</name>
      <url>http://repository.springsource.com/maven/bundles/release</url>
      </repository>
      <repository>
      <id>com.springsource.repository.bundles.external </id>
      <name>SpringSource Enterprise Bundle Repository - External Bundle Releases</name>
      <url>http://repository.springsource.com/maven/bundles/external</url>
      </repository> 
      </repositories>
     
     ...
     <dependency>
     <groupId>javax.resource</groupId>
     <artifactId>com.springsource.javax.resource</artifactId>
     <version>1.5.0</version></dependency> 
     <dependency>
     <groupId>javax.transaction</groupId>
     <artifactId>com.springsource.javax.transaction</artifactId>
     <version>1.1.0</version>
     </dependency>
     

6. Install the artifact (mvn install)
7. Once done, a valid OSGI compliance Oracle driver will be available as Maven artifact into the local repository. In my case  additional (and optional) dependences were required, so the way I followed was to remove them directly from generated MANIFEST.MF file.

   Please note in such a case signing JAR will be useless

   They were:

   1. oracle.security.pki
   2. oracle.ons
   3. oracle.i18n.text.converter
8. Install the osgi artifact in ROO: osgi start --url file:/my_jar_location.jar

   • osgi start --url file:/J:\.m2\repository\javax\resource\com.springsource.javax.resource\1.5.0\com.springsource.javax.resource-1.5.0.jar
     osgi start --url file:/J:\.m2\repository\javax\transaction\com.springsource.javax.transaction\1.1.0\com.springsource.javax.transaction-1.1.0.jar
     osgi start --url file:/J:\.m2\repository\com\oracle\org.bluebell.com.oracle.ojdbc14_g\10.2.0.1.0.0001\org.bluebell.com.oracle.ojdbc14_g-10.2.0.1.0.0001.jar
     

This worked for me, well... ...not at all:

• Spring Forum post