New Roo script for JDBC driver installation for DBRE

[loic_d]

I've turned of my firewall, proxy is set in windows preferences and m2 settings, is there another conf file for Roo proxy?

[shmoo83]

Hi!

I tried installing the mysql-java-connector via the "addon install id" command and after it reached 100% it encountered an exception.

Please take a look at the attached screenshot.

I'm using STS 2.5.2.

[shmoo83]

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

Can you share the URL of the jar you found?

[loic_d]

yep, it think was here :

http://s3browse.springsource.com/bro...a/5.1.13.0001/

[shmoo83]

yep, it think was here :

http://s3browse.springsource.com/bro...a/5.1.13.0001/

Thank you!

[sacharya]

I'm having a similar problem, except that when I launch Roo from an OS shell, it works fine and happily reverse engineers my database.

When I try to run the DBRE from within the Roo shell in STS, it fails and asks me to install the addon; when I try to install the addon, it appears to have succeeded, but ultimately fails again when I try to re-run the DBRE:

roo> database reverse engineer --package ~.domain --schema downloadsite
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
JDBC driver not available for 'com.mysql.jdbc.Driver'
roo> addon install id --searchResultId 1
roo> Target resource(s):
-------------------
Spring Roo - Wrapping - mysql-connector-java (5.1.13.0001)

Deploying...done.

roo> roo> database reverse engineer --package ~.domain --schema downloadsite
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
JDBC driver not available for 'com.mysql.jdbc.Driver'
roo>

How do I make this work in STS?

[shmoo83]

Try downloading the jar from this post.

Then manually install the jar using
osgi install --url <full file path to the mysql jar you downloaded>

[bhagyas]

Please try checking whether your jvm/jdk proxy settings are properly defined.

You can check this by typing 'proxy configuration' in your roo shell.

Cheers!!!

[bhagyas]

It's the jvm proxy. Try looking for a file named net.properties in the location where your jdk/jvm is installed.

Cheers!!!