Sep 11th, 2009, 12:31 PM
Roo and other Databases
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....
Sep 15th, 2009, 05:17 PM
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).