Grails not preserving my DB data

I am building a small Grails application, and I am trying to make the data persist between server restarts in the development environment.

I changed the relevant part of DataSource.groovy to the following:

development {
    dataSource {
        dbCreate = "update" // one of 'create', 'create-drop','update'
     开发者_如何学JAVA   url = "jdbc:hsqldb:mem:devDB"
    }
}

Every time I restart the server, all the data has disappeared. Am I missing another configuration?

I have tried it both with and without sample data in BootStrap.groovy (if that makes any difference).

---

... try dropping the 'mem' part of your url string: jdbc:hsqldb:devDB Right now you're running the db in memory mode, hence the loss of data. Running the db in embedded mode should do what you need.

---

Your url is configured to use an in-memory database. That's what the "mem" in your url string refers to.

I find it easier, especially w/ a small project to use BootStrap.groovy in combination w/ dbCreate="create-drop".

You can change your url to point to a file or relational database, though, if you want to persist w/out using BootStrap.groovy. I'm using grails 2.0 w/ an in memory db.

url = "jdbc:h2:db/devDb;auto_server=true"

Here's an example using mySql (assuming you have a jdbc driver for mysql available):

url = "jdbc:mysql://localhost:8080/foo?autoreconnect=true"

An example w/ file:

url = "jdbc:hsqldb:file:prodDb;shutdown=true"

Hope this helps.

---

You're using an in-memory database, so there's no way for the data survive across server restarts. Switch to a persistent database (MySQL, Postgres, etc.), then set dbCreate = 'validate'

For example, assuming you chose MySQL as your database you'll need to change the settings in DataSource.groovyto:

development {
    dataSource {
        dbCreate = "validate"

        // Put the MySQL JDBC JAR on the classpath of your Grails app
        driverClassName = "com.mysql.jdbc.Driver"

        // Change these property values as needed
        url = "jdbc:mysql://localhost/yourDB"
        username = "yourUser"
        password = "yourPassword"
    }
}