Accessing SQLDB database structure in Grails

Yesterday I needed access the HSQLDB database structure generated by Grails.

I found a tip using DBVisualizer in James Lorenzens’s Blog, a nice tip, but I didn’t want use third tools.

After, I found a excellent tip in act.ualize blog. This tip is exactly what I was looking for: a native tool from HSQLDB.

Indeed, I prefer use the DatabaseManager outside the application. So, I did a little adapt. I opened a new prompt, change current dir to app’s dir and typed this:

java -cp <path_to_grails>/lib/hsqldb-1.8.0.10.jar org.hsqldb.util.DatabaseManager

Now I can access the HSQLSB database (memory or file) outside the grails application.