Grails, an In-Memory HSQL Database and Squirrel

Starting the HQSL Database java -cp c:grails-1.2.0libhsqldb-1.8.0.10.jar org.hsqldb.Server -database.0 mem:devDB -dbname.0 devDB Accessing the DB java -cp c:grails-1.2.0libhsqldb-1.8.0.10.jar org.hsqldb.util.DatabaseManager Grails database connection information, in DataSource.groovy dbCreate = “create-drop” url = “jdbc:hsqldb:hsql://localhost:9001/devDB” username = “sa” password = “” Squirrel wouldn’t start until I correctly quote the CLASSPATH environment variable.