HSQLDB Study Notes

/lib/hsqldb.jar

• HSQLDB RDBMS
• HSQLDB Driver
• Database Manager (Swing and AWT)
• Query Tool (AWT)
• Sql Tool (Command line)

Running tools

• org.hsqldb.util.DatabaseManager
• org.hsqldb.util.DatabaseManagerSwing
• org.hsqldb.util.Transfer
• org.hsqldb.util.QueryTool
• org.hsqldb.util.SqlTool

Running HSQLDB

• mydb.properties
• mydb.script
• mydb.log
• mydb.data
• mydb.backup

Server Modes

• Hsqldb Server: preferred and fastest
• java -cp hsqldb.jar org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb
• Hsqldb Web Server: when only http protocol is allowed
• java -cp hsqldb.jar org.hsqldb.WebServer -database.0 file:mydb -dbname.0 xdb
• Hsqldb Servlet: must be installed into web server e.g. Tomcat
• org.hsqldb.Servlet.java
• Connecting to DB
  Class.forName("org.hsqldb.jdbcDriver");
Connection c = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/xdb","sa","");

In-Process(Standalone) Mode

• Connection c = DriverManager.getConnection("jdbc:hsqldb:file:/opt/db/testdb","sa","");

In-Memory database

Table Types

• TEMP
• Persistent
• Memory
• Cached
• Text