How to configure Grails to work with Apache Derby instead of HSQLDB
A:
You need to have Derby libraries, and configure your DataSources.groovy appropriately. Check out this blog post. It's old, but the instructions might still work.
Jean Barmash
2009-12-08 04:32:23
I found it in google long time ago before I post my question, but no it doesn't work unfortunately!
tranced_UT3
2009-12-08 11:19:44
+1
A:
- Install the derby driver into the lib folder of your application.
Configure the DataSource:
driverClassName = "org.apache.derby.jdbc.ClientDriver"
dbCreate = "create-drop"
url = "jdbc:derby://localhost:1527/theDatabase"Start the derby server.
- Create the empty database (through ij or a graphical sql client).
- Start grails.
Blacktiger
2009-12-08 16:11:09
Good answer! Additionally: if you want to use embedded Derby rather than client-server Derby, change the class name to o.a.d.jdbc.EmbeddedDriver, and then you don't need to start the separate Derby server. You can also cause Derby to create the empty database automatically by adding ";create=true" to the connection URL. If you use the client driver, you'll need derbyclient.jar in your classpath; if you use the embedded driver, you'll need derby.jar in your classpath.
Bryan Pendleton
2009-12-08 17:07:27