New Roo script for JDBC driver installation for DBRE

[muraliweb]

I tried to install the jdbc drivers from with STS. I am getting the following errors. I gather it is because the proxy is not setup.

How can you configure proxy in Spring Roo so that it is possible to download the drivers from Roo without having to manually download, save locally and install from there?


domain roo> script --file install-jdbc-drivers.roo
// Installing OSGi JDBC drivers ...
domain roo>
domain roo> java.net.ConnectException: Connection timed out: connect

domain roo> java.net.ConnectException: Connection timed out: connect

domain roo> java.net.ConnectException: Connection timed out: connect

domain roo> java.net.ConnectException: Connection timed out: connect

domain roo> java.net.ConnectException: Connection timed out: connect
domain roo> java.net.ConnectException: Connection timed out: connect

[Alan Stewart]

Configure the proxy in STS and try again

[muraliweb]

The proxy already is configured in STS (presumably using the Eclipse proxy config settings).

I know this is working as I am able to install software within Eclipse and also in STS. For instance I installed the Roo extension within within the STS Dashboard -> Extensions tab.

[loic_d]

hello,

i can't find the "install-jdbc-driver" script... it seems that it has been removed in the last version. What do we have for replacement?

I can't make MySQL reverse engineer work (JDBC driver not avalaible)

Is there a Jar for mysql to do something like :

osgi install --url file:///d:/springsource/workspace/project/org.springframework.roo.wrapping.hsqldb-1.8.0.10.0001.jar

Thanks,

Loic

[Alan Stewart]

The script is no longer needed and has been removed in favour of on-demand installation with OSGi. Configure your database properties as you normally would do. There are a couple of ways, but I usually just do a database introspect --schema[TAB} or database reverse engineer --schema[TAB]. You will see that an OSGI-enabled driver is available to download. Note its ID (eg "1") and then execute

addon install id --searchId 01

The driver will be downloaded, started and then you can reverse engineer from then on. This is a once only step, providing you don't re-install Roo or delete the OSGi bundle cache directory under Roo's directory structure

[loic_d]

Hi,
thanks for your answer.

When i run database reverse engineer, i have this message :JDBC Driver not avalaible for 'com.mysql.jdbc.Driver'

Does this mean that the ID is 'com.mysql.jdbc.Driver' ?

When i run this command : "addon install id --searchResult com.mysql.jdbc.Driver

it responds : "For input string : com.mysql.jdbc.Driver"

and it doesn't solve the problem


Best regards

Loic

Edit : I managed to install a bundle with this command : ' addon install bundle --bundleSymbolicName org.springframework.roo.wrapping.mysql-connector-java-5.1.13.0001.jar'

But now, after restarting roo, when i run database reverse command i have this message : "Spring Roo automatic add on discovery currently unavailble, JDB driver not avalaible..."


hard!

[loic_d]

Re,

i used antoher method, and it worked.

I've found the org.springframework.roo.wrapping.mysql-connector-java-5.1.13.0001.jar on the web, and i 've run :

osgi start --url file:org.springframework.roo.wrapping.mysql-connector-java-5.1.13.0001.jar

[Alan Stewart]

Does this mean that the ID is 'com.mysql.jdbc.Driver' ?

The ID is the number at the beginning, ie

roo> database introspect --schema unable-to-obtain-connection
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 5.1.13.0001 #jdbcdriver driverclass:com.mysql.jdbc.Driver. This...
--------------------------------------------------------------------------------

[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

[loic_d]

That's strange, when i type 'database introspect --schema unable-to-obtain-connection' i don't have the same message you have.

I have just ' Spring Roo automaticadd-on discovery currently not available JDBC driver not available'

I use the last release (1.1.1)

[Alan Stewart]

The feature is there for 1.1.1. Proxy or firewall issues?