Setting up HSQL 2.0 database

I am going to take a file based HSQL database, mentioning that is
important since HSQL can work as a in memory database too.
An easy way to start multiple hsql databases is by defining then in the
server.properties file. The content for it should look like:

server.database.0=file:./database/mydb
server.dbname.0=mydb

Note that you can defined multiple databases like this with increasing
indexes.
The scripts and properties files for the database are inside the
'database' folder i.e. mydb.script and mydb.properties.
Lets say if you are starting from scratch then, the content for them can
be copied from any test.script and test.properties file.
And these test files are generated automatically when you don't defined
a db to HSQL while starting it.