Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.

Lexical Tools

HSqlDb 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

Usage Summary

  • download hsqldb.jar
  • 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

References

Please refer to HSQL Database Engine Web site.