Hsqldb installation is very easy. Just extract the file in the archive. That's it!
Following shows steps to startup the database server.
Let's create new folder to hold database files.
Select File - New - Folder.
Let's name the folder data. It seems Hsqldb script files use data.
Create server.properties file in folder data with the following script.
The script tells Hsqldb to name the database file demo and use port 9001 for management access (this this the default port number). server.properties
It is possible to start and maintain Hsqldb by typing Java commands but since
that's tiresome, let's just copy them from the demo folder.
Files to copy are:
runManager.bat - GUI utility to execute SQL commands
runManagerSwing.bat - Same as runManager.bat but with Swing
runServer.bat - Script to start Hsqldb database server
runUtil.bat - Script to use Hsqldb utilities
runWebServer.bat - Script to start Hsqldb web server
Select these file with your mouse. Press the Ctrl
key while clicking the left mouse button to select multiple files at once.
Keep pressing the Ctrl and the left mouse button while
dragging the mouse pointer to the data folder. Release the mouse to copy the files.
Move to the data folder and check that the files were copied.
It's finally time to start up the Hsqldb server!
Select the runServer.bat file.
A console window should open and display database server start up process. Do not close this window! Proceed to the next page to
properly shutdown the server.
If the console window closes, it means there is something wrong. Recheck of each step.