Roo and other Databases

[Don Stadler]

There were lots of comments about Roo not working with MySQL. I encountered the same problem and solved it in a rather unscientific way.

First I downloaded and installed MySQL 5.1. Not sure whether this is strictly necessary but I figured it might be doing fancy autodetect magic. Comments, anyone?

Then I created a new Roo project rather than trying to change the old one.

That worked. Just follow the tutorial for the new project but use:

install jpa -provider HIBERNATE -database MYSQL

in lieu of

install jpa -provider HIBERNATE -database HYPERSONIC_PERSISTENT

Roo doesn't appear to be able to change this in an existing project, though you could try blowing away the generated DB files which Ben mentions, then rerunning....

[Ben Alex]

You could try the "update jpa" command instead of "install jpa". Also note for mySql you'll need to use "database set" to modify the connection details (or manually edit database.properties).