Installing and configuring HSQLDB Database

1- Instroduction

In this document, I will show you:
  • Download software HSQLDB (~ 8MB)
  • Create example database SimpleHr
  • Configuring and running HSQLDB.
All just 5 minutes.

2- Download HSQLDB

Unzip the downloaded zip file to a specific folder.

3- Configure & run HSQLDB

The HSQLDB Server configuration and run a very simple, first you need to install Java (Version> 5) on your computer.
Make sure you have configured environment variables JAVA_HOME and Path.
Add the location of Java bin directory into Path.
Finally, run the file runServer.bat in the bin directory of HSQLDB.
HSQLDB Database was start, you do not turn it off.
If you do not want to configure the environment variables JAVA_HOME and Path as above, the simplest way is declare the variable Path in the file runServer.bat:

4- Create example database SimpleHr

In the above steps, you have installed HASQLDB software and its configuration. Next, we create an example database. You can download an example database ( Simplehr) at:

Note: All of simplehr database is a unique file named simplehr.script

If HSQLDB is running, you should stop it.

Unzip the downloaded file
  • Delete all the files in the data directory of HSQLDB.
  • Copy file simplehr.script to the data directory of HSQLDB.
Add file server.properties in the data directory of HSQLDB.
  • server.properties
server.database=simplehr
server.port=9001
rerun file runServer.bat:
In the data folder of HSQLDB, some files automatically created for the purpose of management of  HSQLDB.
Everything was ready. You need a visual tool to work with this database, there are many tools to do it.

5- Configure HSQLDB Datasouce on Eclipse

Eclipse can become a visual tool to work with HSQLDB Database. The configuration is very simple and only takes 2 minutes to do this. You can see the instructions at: