Suppose you use HSQL in-file database, and you want to be able to execute SQL commands against it.
Suppose your set up is like so:
- script file is mydatabase.script and it’s located in D:\Development\project\mydatabase.script
- HSQL is located in D:\hsqld
Here is what you need to do:
Start an instance of the HSQL server:
cd D:\Development\project
java -cp D:\hsqldb\lib\hsqldb.jar org.hsqldb.Server -database.0 file:project -dbname.0 mydatabase
Connect to it with the HSQL manager. Provide the following connection string:
jdbc:hsqldb:file:D:\Development\project\mydatabase
You should now be able to see the tables in the database and execute SQL commands agains them.
