(How To) Run Hypersonic SQL (HSQL) as a HSQL Server

1) Place the hsqldb.jar in a folder where you want to create the database
2) In command prompt, execute the command:

java -cp hsqldb.jar org.hsqldb.server.Server --database.0 

                     file:/data/learning --dbname.0 phonebook

- /data/learning is the location where the database will be created.
- "phonebook" is alais name used to refer to the database. This also hides the actual database from the clients.
- Settings to connect to the database from HSQL Database Manager is shown below: