Unable to get connection from driver

[hkadejo]

I run database introspect --schema myschema and ...
message error "Unable to get connectio from driver".
my OS is Windows XP and JDK 1.6.0_18.

[Alan Stewart]

What database? Have you specified the correct database.url property, username and password?

[hkadejo]

MySql and all the properties are well.

#Updated at Wed Aug 25 13:02:26 CST 2010
#Wed Aug 25 13:02:26 CST 2010
database.password=
database.url=jdbc\:mysql\://localhost\:3306\jedisv
database.username=root
database.driverClassName=com.mysql.jdbc.Driver

[Alan Stewart]

You should use a forward slash between the port and the database name.

[hkadejo]

Thank you very much

[alexmc6]

Argh. I got stung by the same thing.

Also I left the \: in there without specifying the default port. That broke it too.

[divadsirrah]

I get the Unable to get connection from driver message
I ran the install-jdbc-drivers.roo before attempting. Would it be possible to get pre release 1.1.1 pdf documentation?

log.roo file attached

[Alan Stewart]

With HYPERSONIC_PERSISTENT, I assume you have the database running in a different window or service? For example, to access hsql persistent db's, I need to run a command like the following first (in linux):

java -cp /home/stewarta/.m2/repository/org/hsqldb/hsqldb/1.8.0.10/hsqldb-1.8.0.10.jar org.hsqldb.Server --database.0 file:tmp/roo1696 --dbname.0 xdb

[divadsirrah]

Hi Alan,

No I was running it in pure standalone mode with the file url. It worked that way in a separate non Spring Roo project that used Hibernate. Should I be running it as a server? Does roo work using a persistent embeded database? I would be using this just during development time

[Alan Stewart]

Regards to the documentation, if you do get the latest code from Git and do a mvn assembly:assembly, it will generate a PDF in and is contained in the distribution zip