populating in memory hsqldb database from script

问题:

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 starting and stopping hsqldb from unit tests

回答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.