Before you start, you will need to make sure that your x11 is working. Follow this page for instructions or do further research for your platform.
I’ve used this DatabaseManager database manager
To Run client in a gui form do:
java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing --noexit --dir /location/to/database
if its a file based database u’d need to specify the following url:
jdbc:hsqldb:file:/location/to/database