HSQLDB

• HSQLDB (HyperSQL DataBase) is the leading SQL relational database engine written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools.

http://hsqldb.org/

• HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92 and SQL:2008 standards.[1] It offers a fast,[2] small (around 1300 kilobytes in version 2.2) database engine which offers both in-memory and disk-based tables. Both embedded and server modes are available for purchase.

Additionally, it includes tools such as a minimal web server, command line and GUI management tools (can be run as applets), and a number of demonstration examples. It can run on Java runtimes from version 1.1 upwards, including free Java runtimes such as Kaffe.

HSQLDB is available under a BSD license. It is used as a database and persistence engine in many open source software projects, such as OpenOffice Base, LibreOffice Base, and the Standalone Roller Demo,[3] as well as in commercial products, such as Mathematica or InstallAnywhere (starting with version 8.0)
http://en.wikipedia.org/wiki/HSQLDB

• 1. The dialect is set to the database we are using which is HSQLDB

2. The JDBC driver is also set to HSQLDB
3. We set the database to one called testdb and request that the database be shutdown when our program exits
4. The default user name and passwords are used (change if yours differs)
5. I use the create-drop option to create the database and table(s) if they doesn’t exist, if they do they are dropped leaving me with a clean database each time I run the program. Other options are: create, update and validate

http://www.giantflyingsaucer.com/blog/?p=2902

• querying using hsql database manager :

select your connection

    type: HSQL DATABASE ENGINE SERVER
    Driver: jdbc.hsqldb.jdbcDriver
    URL: jdbc:hsqldb:hsql://localhost/