Announcement Announcement Module
Collapse
No announcement yet.
Unable to find the JTDS driver Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to find the JTDS driver

    Hi,

    I am new to Roo (and spring) and I am just trying to reverse engineer one of our MS SQL databases.

    I am having difficulties installing the driver. When I try to perform an operation on the database I am getting:

    addon search --requiresDescription "#jdbcdriver,driverclass:net.sourceforge.jtds
    .jdbc.Driver" found no matches
    JDBC driver not available for 'net.sourceforge.jtds.jdbc.Driver'
    roo>

    When I run

    roo>addon search jtds

    0 found, sorted by rank; T = trusted developer; R = Roo 1.2 compatible
    ID T R DESCRIPTION ------------------------------------------------------------

    -------------------------------------------------------------------------------

    [HINT] use 'addon info id --searchResultId ..' to see details about a search re
    ult
    [HINT] use 'addon install id --searchResultId ..' to install a specific search
    esult, or
    [HINT] use 'addon install bundle --bundleSymbolicName TAB' to install a specifi
    add-on version

    listing all the addons I don't see it at all...

    roo> addon list
    17 found, sorted by rank; T = trusted developer; R = Roo 1.2 compatible
    ID T R DESCRIPTION -------------------------------------------------------------

    01 - Y 1.0.0.0001 This bundle wraps the standard Maven artifact:
    google-collections-1.0.0.
    02 - Y 9.0.0.801_jdbc4_0001 PostgreSQL #jdbcdriver
    driverclass:org.postgresql.Driver. This bundle wraps the standard...
    03 - Y 2.0.0 Addons that adds Content Negotiating View Resolver configuration
    to your application context: MVC multiple representations By default...
    04 - Y 2.0.0 The Executable WAR Addon configures the Maven project to makes it
    possible to create web applications that can be run from the command...
    05 - - 1.3.2 This project provides an addon for Spring Roo which aims to
    generate equals() and hashCode() methods.
    06 - Y 0.9.9 Installs jQuery UI
    07 - - 0.1.4 The Http-Proxy Addon allows you to configure your web application
    to get around the Same Origin Policy restriction (e.g. cross-domain)....
    08 - Y 2.0.0.v201106070531 This bundle wraps the standard Maven artifact:
    org.eclipse.xtext.xtend2.lib-2.0.0.v201106070531.
    09 - Y 2.0.0 JAXB2 Schema complier addon. It adds the maven-jaxb2-plugin to
    your pom.xml. The plugin participates in the generate-code phase and...
    10 - Y 2.2.1 This bundle wraps the standard Maven artifact:
    org.eclipse.xtext.xtend2.lib-2.2.1.
    11 Y Y 0.1.1.RELEASE A simple add-on to allow execution of native OS commands
    from the Roo shell
    12 - Y 2.0.0.v201106070531 This bundle wraps the standard Maven artifact:
    org.eclipse.xtext.xbase.lib-2.0.0.v201106070531.
    13 - Y 1.1.0 Spring Security OAuth2 AutorizationServer/ResourceServer/Client
    Configuration
    14 - - 1.0.0 This project provides an addon for Spring Roo generates equals()
    and hashCode() methods. It uses Xtend2 for code generation.
    15 - Y 1.1.1 Spring Roo addon for creating rich internet applications with
    Vaadin.
    16 - Y 10.0.1.0001 This bundle wraps the standard Maven artifact:
    google-guava-10.0.1.
    17 - Y 0.9.0 Adds the coffeescript maven compiler
    --------------------------------------------------------------------------------

    [HINT] use 'addon info id --searchResultId ..' to see details about a search res
    ult
    [HINT] use 'addon install id --searchResultId ..' to install a specific search r
    esult, or
    [HINT] use 'addon install bundle --bundleSymbolicName TAB' to install a specific
    add-on version
    roo>



    I am running the lastest roo 1.2.1 installed with STS 2.9.2

    Any ideas?

    Thanks,

    Wade

  • #2
    I am having exactly the same problem. If by now you know the solution, please let me know.

    Comment


    • #3
      I did some research and finally the problem is solved. I created my own add-on of type 'wrapper':
      1. Create a directory and navigate to it.
      2. Open a roo shell.
      3. Issue the following add-on project creation command:
      "roo> addon create wrapper --groupId net.sourceforge.jtds --artifactId jtds --version 1.2.4 --topLevelPackage com.mycompany.bundles --vendorName "Apache Software Foundation" --licenseUrl "http://www.apache.org/licences/LICENCE-2.0" --projectName jtds-1.2.4-wrapper"
      4. Needed to update the "pom.xml", added the dependency "jcifc"
      ...
      <dependency>
      <groupId>jcifs</groupId>
      <artifactId>jcifs</artifactId>
      <version>1.3.17</version>
      </dependency>
      ...
      5. "roo> perform command --mavenCommand bundle:bundle"
      6. Finally install the bundle into the Roo shell:
      "roo> osgi start --url file:///path-to-jar-file/target/com.mycompany.bundles.jtds-1.2.4.0001.jar"
      Last edited by alcarrillo; Jul 10th, 2012, 08:14 PM. Reason: Typo fixed

      Comment


      • #4
        Hi ACarrillo, try to follow your recipe, but had no success. Continuous unable to perform reverse engineering to SQL SERVER, any other ideas? thank you very much for your time.

        Comment


        • #5
          Cristian,

          The hardest part is about creating the wrapper, I mean the jar file. Let me know if you want me to send you the jar file I did, then you only should install de bundle into the Roo shell (step 6).

          Comment


          • #6
            Thanks for the response alcarrillo, please if you can, would appreciate your help. i am testing many situations but i cant do "database introspect" with MS SQL. The rare is the message "JDBC driver not available for "net.sorceforge.jtds.jdbc.driver"".
            Try with sts 2.8.0, 2.9.0,1,2 and always is the same response. Also try with SQL 2005 and 2008 with the same way.
            Considering that previously sts-2.9.0 with SQL 2006 works fine.

            Comment


            • #7
              Manually install from here....

              http://sourceforge.net/projects/jtds/files/

              then do an

              OSGI start --url file:

              with the location of the installed jar file typed in after "file:"

              Comment


              • #8
                Thanks Ericmc !!! worked correctly.....

                Comment

                Working...
                X