HSQL Database
Description
HSQL Database Engine (HSQLDB) is a lightweight 100% Java SQL database engine developed at SourceForge since April 2001. 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. It is complete free under its licenses.
Capability
It is 100% pure Java database. Accordingly, it is easy for distribution
Features supported a rich subset of ANSI-92 SQL (BNF tree format)
Offers a small, fast, stable, and reliable database
Provides both embedded and server modes
Provides both in memory and disk based tables
Limitations
It is free under HSqlDb licence
Usage Summary
download hsqldb.jar to ${LA_DIR}/lib/jdbcDrivers/HSqlDb
Use JDBC in Java to perform database query
jdbc driver: org.hsqldb.jdbcDriver
jdbc url: jdbc:hsqldb:/$path/$DB_NAME
username: sa
password: ""
Change readonly=true in $DB_NAME.proiperties file after loading all tables
References
Please refer to HSQL Database Engine Web site.