populating in memory hsqldb database from script

Question

Is there a way that I can specify a script in the connection string pointing to my in memory hsqldb instance?

I was looking at this article and it looks like it is possible, but I'm not sure how to formulate the string correctly or where to put the script file. Looking at the hsqldb documentation here it doesn't appear to be the case.

What would my options here be for using this from java tests?

This is related to a previous hsqldb question here http://stackoverflow.com/questions/3018066/starting-and-stopping-hsqldb-from-unit-tests

Answer 1

Use a file: database instead of mem:, but include "files_readonly=true" in the properties file. Changes to the database during tests will not be persisted.