Announcement Announcement Module
Collapse
No announcement yet.
JTDS Driver not available Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • JTDS Driver not available

    I installed jtds driver (for accessing MS SQL Server) using spring-roo-1.1.2.BUILD-SNAPSHOT. But I keep getting "JDBC driver not available for 'net.sourceforge.jtds.jdbc.Driver'" when doing database introspect.

    roo> database introspect --schema no-schema-required --file
    Located add-on that may offer this JDBC driver
    1 found, sorted by rank; T = trusted developer; R = Roo 1.1 compatible
    ID T R DESCRIPTION -------------------------------------------------------------
    01 Y Y 1.2.4.0001 #jdbcdriver driverclass:net.sourceforge.jtds.jdbc.Driver....
    --------------------------------------------------------------------------------
    [HINT] use 'addon info id --searchResultId ..' to see details about a search result
    [HINT] use 'addon install id --searchResultId ..' to install a specific search result, or
    [HINT] use 'addon install bundle --bundleSymbolicName TAB' to install a specific add-on version
    JDBC driver not available for 'net.sourceforge.jtds.jdbc.Driver'

    Thanks,
    Jin

  • #2
    Hi Jin,

    Can you confirm you installed the driver?

    Code:
    roo> addon search jtds 
    1 found, sorted by rank; T = trusted developer; R = Roo 1.1 compatible
    ID T R DESCRIPTION -------------------------------------------------------------
    01 Y Y 1.2.4.0001 #jdbcdriver driverclass:net.sourceforge.jtds.jdbc.Driver.
           This bundle wraps the standard Maven artifact: jtds-1.2.4.
    --------------------------------------------------------------------------------
    ...
    roo> addon install id --searchResultId 01
    Target resource(s):
    -------------------
       Spring Roo - Wrapping - jtds (1.2.4.0001)
    
    Deploying...done.
    
    Successfully installed add-on: Spring Roo - Wrapping - jtds [version: 1.2.4.0001]
    ...
    roo> osgi ps
    If you issue the 'osgi ps' command, does it list the jdts driver at the end of the list? It should read something like this:

    [ 74] [Active ] [ 1] Spring Roo - Wrapping - jtds (1.2.4.0001)

    Comment


    • #3
      I don't see success info ...

      / __ \/ __ \/ __ \
      / /_/ / / / / / / /
      / _, _/ /_/ / /_/ /
      /_/ |_|\____/\____/ 1.1.2.BUILD-SNAPSHOT [rev 0b7272c]


      Welcome to Spring Roo. For assistance press CTRL+SPACE or type "hint" then hit ENTER.
      roo> addon search jtds
      1 found, sorted by rank; T = trusted developer; R = Roo 1.1 compatible
      ID T R DESCRIPTION -------------------------------------------------------------
      01 Y Y 1.2.4.0001 #jdbcdriver driverclass:net.sourceforge.jtds.jdbc.Driver.
      This bundle wraps the standard Maven artifact: jtds-1.2.4.
      --------------------------------------------------------------------------------
      [HINT] use 'addon info id --searchResultId ..' to see details about a search result
      [HINT] use 'addon install id --searchResultId ..' to install a specific search result, or
      [HINT] use 'addon install bundle --bundleSymbolicName TAB' to install a specific add-on version
      roo> addon install id --searchResultId 01
      roo> Target resource(s):
      -------------------
      Spring Roo - Wrapping - jtds (1.2.4.0001)

      Deploying...done.

      roo> roo>

      Comment


      • #4
        jtds driver is installed

        Thanks, Stefan

        Yes, the driver is installed. I think I have the database connection issue,
        [ 68] [Active ] [ 1] Spring Roo - Wrapping - jtds (1.2.4.0001)

        Jin,

        Comment


        • #5
          Hi Stefan,
          I'm in the same position as Jin, however I cannot find the jtds in the list produced by the command "osgi ps".


          my installation is:
          <roo.version>1.1.5.RELEASE</roo.version>
          <spring.version>3.0.5.RELEASE</spring.version>
          <aspectj.version>1.6.11</aspectj.version>

          is there a way to make it active?

          Cheers.

          Comment


          • #6
            i've gotten a bit further...

            i think my work proxy was affecting it (or so i believe). I grabbed the jar for "org.springframework.roo.wrapping.mysql-connector-java" and put it into %ROO_HOME%/bundles

            this then gave a different error:

            roo> database reverse engineer --schema helloworld --package ~.model
            addon search --requiresDescription "#jdbcdriver,driverclass:com.mysql.jdbc.Driver " found no matches
            JDBC driver not available for 'com.mysql.jdbc.Driver'
            roo>

            It is odd as it was in the pom file and also downloaded into my maven repo. So i added it again to %ROO_HOME%/bundles but still doesn't work..

            Comment


            • #7
              works now.
              I just had to restart my STS!

              Comment

              Working...
              X