CODEWITHSUNDEEP
javaunit-testingintegration-testinghsqldb
user147373
user147373

Reputation:

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

Upvotes: 4

Views: 3427

Answers (1)

fredt
fredt

Reputation: 24382

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.

Upvotes: 1

Related Questions