I downloaded the HyperSQL package (hsqldb-2.2.8.zip) and extracted its contents into the "C:\Program Files\hsqldb" folder.
Starting an HSQLDB Server
The following example command starts the HyperSQL server with one database called "mydb" and the public name of "xdb". The public name hides the file names from users.
If the files named "mydb.*" do not already exist, they will be created. This way you can start the HSQLDB server and create a new database at the same time.
If the computer hosting the database server is restricted to the HTTP protocol by a firewall, use the HyperSQL HTTP Server.
When a HyperSQL server is running, client programs can connect to it using the HSQLDB JDBC Driver contained in hsqldb.jar.
Running Database Access Tools
HyperSQL includes the Database Manager JDBC frontend to connect to a HSQLDB server, query and modify tables.
At the Connect dialog, enter the information necessary for connecting to the database.
SQL CommandsAfter I started the Database Manager using the command above, I entered the following SQL commands to create tables for MyBooks database.
When you finish using the Database Manager, make sure that you properly shut down the database.
SHUTDOWN: To save changes and close the database.
SHUTDOWN COMPACT: To save the database in the minimal size and close it. Should be used periodically.
Using OpenOffice.org Base to Work with HSQLDB ServerYou can use OpenOffice.org Base to work with a server-based HyperSQL database. First, you need to set up OpenOffice.org so that it can use the HyperSQL JDBC driver. Select Tools > Options > Java and click Class Path.
OpenOffice.org and Java
OpenOffice.org Base may not work if it can't find Java. In that case, set JAVA_HOME to the Java installation directory and include in PATH the folder containing java.exe.