JTDS Driver not available available, developer, database, getting

amy

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

roogt; 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

Hi Jin,

Can you confirm you installed the driver?Code:
roogt; 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.
--------------------------------------------------------------------------------
...
roogt; 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]
...
roogt; 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)

/ __ \/ __ \/ __ \  / /_/ / / / / / / / / _, _/ /_/ / /_/ /  
/_/ |_|\____/\____/    1.1.2.BUILD-SNAPSHOT [rev 0b7272c]Welcome to Spring Roo. For assistance press CTRL+SPACE or type quot;hintquot; then hit ENTER.
roogt; 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
roogt; addon install id --searchResultId 01
roogt; Target resource(s):
-------------------  Spring Roo - Wrapping - jtds (1.2.4.0001)

Deploying...done.

roogt; roogt;

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,