New Roo script for JDBC driver installation for DBRE

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

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.

Quote:

---

Originally Posted by 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

---

Can you share the URL of the jar you found? :D

yep, it think was here :

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

Quote:

---

Originally Posted by loic_d

yep, it think was here :

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

---

Thank you! :)

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:

Quote:

---

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?

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>

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

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

Cheers!!!