Install HSQLDB Database on Windows
In this document, I will show you:
- Download software HSQLDB (~ 8MB)
- Create example database: SimpleHr
- Configuring and running HSQLDB.
All just 5 minutes.
Unzip the downloaded zip file to a specific folder.
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 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:
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.
rerun file runServer.bat:
In the data folder of HSQLDB, some files automatically created for the purpose of management of HSQLDB.
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: