Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Complete
    • Affects Version/s: 1.1.1.RELEASE
    • Fix Version/s: 1.1.1.RELEASE
    • Component/s: @ RESOURCES
    • Labels:
      None
    • Environment:
      Mac OSX 10.6.5, Java 6, Maven 2.2.1, Spring Roo 1.1.0-RELEASE

      Description

      I'm trying to use DBRE against an Oracle database with Roo 1.1.0-RELEASE with no success so far.

      roo> database reverse engineer 
      No remote OBR repositories have matching add-ons matching your request
      JDBC driver not available for 'oracle.jdbc.OracleDriver'
      

      I looked around in the internet and found a suggestion to run the following:

      roo> script --file install-jdbc-drivers.roo
      

      But that fails when trying to download the oracle driver:

      java.io.FileNotFoundException: 
      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
      

      I'm attaching the Roo log and console output.

      1. log.roo
        2 kB
        Alexander Rodriguez
      2. roo.console
        2 kB
        Alexander Rodriguez

        Issue Links

          Activity

          Hide
          Ben Alex added a comment -

          Unfortunately Oracle JDBC drivers are no longer in the SpringSource Enterprise Bundle Repository (EBR) due to licensing restrictions. This means the install script is no longer able to download these resources and you will need to manually package the Oracle JARs into a suitable OSGi bundle for use with Roo. We know this is a suboptimal situation but there's not much we can do about it.

          I'm reassigning this ticket to Alan to document in the reference guide the new situation with Oracle. With a bit of luck we can make a wrapping command to slightly ease the pain in Roo 1.1.2 for those who already have the Oracle JARs but not in OSGi compliant form.

          Show
          Ben Alex added a comment - Unfortunately Oracle JDBC drivers are no longer in the SpringSource Enterprise Bundle Repository (EBR) due to licensing restrictions. This means the install script is no longer able to download these resources and you will need to manually package the Oracle JARs into a suitable OSGi bundle for use with Roo. We know this is a suboptimal situation but there's not much we can do about it. I'm reassigning this ticket to Alan to document in the reference guide the new situation with Oracle. With a bit of luck we can make a wrapping command to slightly ease the pain in Roo 1.1.2 for those who already have the Oracle JARs but not in OSGi compliant form.
          Hide
          Alexander Rodriguez added a comment -

          Could you point me out to instructions on how to package any JAR into a suitable OSGi bundle? I'm assuming that to add the JARs to Roo I'll have to use the 'osgi install' command, right?

          Show
          Alexander Rodriguez added a comment - Could you point me out to instructions on how to package any JAR into a suitable OSGi bundle? I'm assuming that to add the JARs to Roo I'll have to use the 'osgi install' command, right?
          Hide
          Alan Stewart added a comment -

          Updated the dbre reference docs in Git ID 2552f10e3c077d53f38a82f9c361f8a4bd0450b7.

          To wrap jars, there are examples in Roo's wrapping directory.

          Show
          Alan Stewart added a comment - Updated the dbre reference docs in Git ID 2552f10e3c077d53f38a82f9c361f8a4bd0450b7. To wrap jars, there are examples in Roo's wrapping directory.
          Hide
          Ben Alex added a comment -

          To assist people affected by this issue, we have added an "addon create wrapper" command to Roo 1.1.1. This allows you to wrap the required Oracle drivers, which can subsequently be started using the "osgi start" command. Please see ROO-1937 for details. We hope this assists work around the driver distribution problem.

          Show
          Ben Alex added a comment - To assist people affected by this issue, we have added an "addon create wrapper" command to Roo 1.1.1. This allows you to wrap the required Oracle drivers, which can subsequently be started using the "osgi start" command. Please see ROO-1937 for details. We hope this assists work around the driver distribution problem.
          Hide
          Alan Stewart added a comment -

          Removed install-jdbc-drivers.roo script in Git ID 0f6fdb63df13f36f28bbc96db3552c634976eec6 as it us redundant now

          Show
          Alan Stewart added a comment - Removed install-jdbc-drivers.roo script in Git ID 0f6fdb63df13f36f28bbc96db3552c634976eec6 as it us redundant now

            People

            • Assignee:
              Alan Stewart
              Reporter:
              Alexander Rodriguez
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: