HSQLDB Console Quick Start

The Hypersonic database is a very capable and stable implementation. Running the console, i.e., the DatabaseManager class, creates the file folder Inventory (the database name given on the URL) in the data/database folder.

C:\dev\java\hsqldb\data>java -classpath .;../lib/hsqldb.jar org.hsqldb.util.DatabaseManager 
-user sa -url jdbc:hsqldb:database/Inventory

create table Products (productId integer Generated By Default As Identity, 
                   name varchar(50), 
                   cost decimal(10,2), 
                   price decimal(10,2));

insert into Products (name, cost, price) 
values('Widget', 10.20, 20.10);

See documentation: http://hsqldb.org/doc/guide/ch01.html http://hsqldb.org/doc/guide/ch02.html