Install HSQLDB Database on Windows

View more Tutorials:

Websites to learn foreign languages for free:
Follow us on our fanpages to receive notifications every time there are new articles. Facebook Twitter

1- Introduction

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 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.

rerun file runServer.bat:
In the data folder of HSQLDB, some files automatically created for the purpose of management of HSQLDB.

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:

View more Tutorials: