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.