Unable to find the JTDS driver

[wade.clinton]

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

[alcarrillo]

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

[alcarrillo]

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"

[cristian.stolarowa]

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.

[alcarrillo]

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

[cristian.stolarowa]

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.

[ericmc]

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:"

[cristian.stolarowa]

Thanks Ericmc !!! worked correctly.....