HSQLDB (HypersonicSQL)

HSQLDB is a relational database engine written in Java, with a JDBC driver, supporting a rich subset of ANSI-92 SQL (BNF tree format). It offers a small (less than 160k), fast database engine which offers both in memory and disk based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets) and a number of demonstration examples.

To use an HSQLDB database with an Enhydra application

1. In the application configuration file <appName>/output/conf/<appName>.conf (or better, in <appName>/input/conf/<appName>.conf.in ) set the following line:

DatabaseManager.DB.<database_id>.Connection.Url = “jdbc:hsqldb:hsql://<hostName>:<port>”

where <hostName> is the host name or IP adress of computer with runing database server, and <port> is port where database server wait for request (default: 9001).

2. In the same configuration file, identify the JDBC driver with the line:

DatabaseManager.DB.<database_id>.JdbcDriver = ”org.hsqldb.jdbcDriver "

3. Add the path to hsqldb.jar to the setting for CLASSPATH in the application’s run script, in <appName>/run, or better in . <appName>/run.in.

This is the link where you can find all needed information and downloads for HSQLDB database:

http://hsqldb.sourceforge.net