HSQLDB is a relational database engine written 100% in Java , with a JDBC driver. This supports a subset of ANSI-92 SQL. It is best known for its small size, ability to execute completely in memory and its speed. It offers a small (about 100k), fast database engine which offers both in memory and disk based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets or servlets, too) and a number of demonstration examples.This is currently being used as a database and persistence engine in many Open Source Software projects and even in commercial projects and products! It is free under the Modified BSD License.
HSQLDB home : here
Features of hsqldb : here
Known problems with hsqldb: here
Technorati Tags : HSQLDB,
Orange Slate 
Google is the best search engine
what is the benifits of hsqldb over sqlite and visa versa? I need to build an administration service over csv file that has a large amounts of records more than 100 thousands. what is the best for this?
thanks