How to configure Grails to work with Apache Derby?

How to configure G开发者_StackOverflow社区rails to work with Apache Derby instead of HSQLDB

---

1. Install the derby driver into the lib folder of your application.

2. Configure the DataSource:

   driverClassName = "org.apache.derby.jdbc.ClientDriver"
   dbCreate = "create-drop"
   url = "jdbc:derby://localhost:1527/theDatabase"

3. Start the derby server.

4. Create the empty database (through ij or a graphical sql client).
5. Start grails.

---

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.

---

Configuration for grails 3 in application.yml

        dataSource:
            dbCreate: create-drop
            driverClassName: org.apache.derby.jdbc.EmbeddedDriver
            url: jdbc:derby:memory:db;create=true

And build.gradle

dependencies {
   runtime 'org.apache.derby:derby:10.12.1.1'
   //... other dependencies
}