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.