Spring Roo
  1. Spring Roo
  2. ROO-1354

OSGi jTDS JDBC driver shipped with Roo for MSSQL and Sybase does not work when using DBRE

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Complete
    • Affects Version/s: 1.1.0.M3
    • Fix Version/s: 1.1.0.RC1
    • Component/s: BUILD, PERSISTENCE
    • Labels:
      None

      Description

      Though the wrapped jTDS driver is shipped in the Roo 1.1.0.M3 distribution, database introspection and reverse engineering do not work. Error given is:
      No Spring Roo add-ons were found that offer a similar JDBC driver
      JDBC driver not available for 'net.sourceforge.jtds.jdbc.Driver'

        Issue Links

          Activity

          Hide
          Mduduzi Keswa added a comment -

          The following line in .../addon-jdbc/pom.xml:

          <Import-Package>*,net.sourceforge.jtds;resolution:=optional,com.mysql.jdbc;resolution:=optional,org.apache.derby.jdbc;resolution:=optional,oracle.jdbc;resolution:=optional,org.h2;resolution:=optional,org.hsqldb;resolution:=optional,org.postgresql;resolution:=optional</Import-Package>

          ...must be changed to:

          <Import-Package>*,net.sourceforge.jtds.jdbc;resolution:=optional,com.mysql.jdbc;resolution:=optional,org.apache.derby.jdbc;resolution:=optional,oracle.jdbc;resolution:=optional,org.h2;resolution:=optional,org.hsqldb;resolution:=optional,org.postgresql;resolution:=optional</Import-Package>

          Basically, we were referring to 'net.sourceforge.jtds' instead of 'net.sourceforge.jtds.jdbc'

          I hope this helps.

          -Mdu

          Show
          Mduduzi Keswa added a comment - The following line in .../addon-jdbc/pom.xml: <Import-Package>*,net.sourceforge.jtds;resolution:=optional,com.mysql.jdbc;resolution:=optional,org.apache.derby.jdbc;resolution:=optional,oracle.jdbc;resolution:=optional,org.h2;resolution:=optional,org.hsqldb;resolution:=optional,org.postgresql;resolution:=optional</Import-Package> ...must be changed to: <Import-Package>*,net.sourceforge.jtds.jdbc;resolution:=optional,com.mysql.jdbc;resolution:=optional,org.apache.derby.jdbc;resolution:=optional,oracle.jdbc;resolution:=optional,org.h2;resolution:=optional,org.hsqldb;resolution:=optional,org.postgresql;resolution:=optional</Import-Package> Basically, we were referring to 'net.sourceforge.jtds' instead of 'net.sourceforge.jtds.jdbc' I hope this helps. -Mdu
          Hide
          Alan Stewart added a comment -

          Thanks. Checked this change in Git ID f8877afdc79aa7ae9665a0171d635ec48d73509d. Please build Roo and test.

          Show
          Alan Stewart added a comment - Thanks. Checked this change in Git ID f8877afdc79aa7ae9665a0171d635ec48d73509d. Please build Roo and test.
          Hide
          Alan Stewart added a comment -

          Above fix verified to work with MS SQL and Sybase.

          Show
          Alan Stewart added a comment - Above fix verified to work with MS SQL and Sybase.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: