Monday, August 27, 2007

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: