JTDS Driver not available

[jinqin2003]

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

[Stefan Schmidt]

Hi Jin,

Can you confirm you installed the driver?

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)

[jinqin2003]

/ __ \/ __ \/ __ \
/ /_/ / / / / / / /
/ _, _/ /_/ / /_/ /
/_/ |_|\____/\____/ 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>

[jinqin2003]

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,

[spring_rain]

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.

[spring_rain]

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..

[spring_rain]

works now.
I just had to restart my STS!