Hypersonic comes with fairly good docs and a sample db so
you should start wit those and modify to suit.
HSQLDB can run in many forms, one of the easiest is 'in process', meaning the database only gets created as soon as you try to connect to it - it behaves like a RDBMS but really it's just a library attached to your app which stores and retrieves data. I recommend placing the db files in an absolute location on your drive.
The problem initially is that first time you call the db it will be empty, not even any tables, and setting this up in an application is annoying. In the demo directory you will find a 'runManager' app which you can use to get started.
Create the following files in the /temp directory:
sampleDB.properties
sampleDB.script
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE V_TABLE_USER(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,CN VARCHAR(40) NOT NULL,OU VARCHAR(40) NOT NULL,TITLE VARCHAR(10),FN VARCHAR(10) NOT NULL,SN VARCHAR(10) NOT NULL,MAIL VARCHAR(100),ROLE VARCHAR(5) NOT NULL,MEMBERTYPE VARCHAR(6) NOT NULL,GENDER VARCHAR(1) NOT NULL,USERPASSWORD VARCHAR(40),CONSTRAINT SYS_CT_64 UNIQUE(CN,OU))
ALTER TABLE V_TABLE_USER ALTER COLUMN ID RESTART WITH 5
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO V_TABLE_USER VALUES(1, 'person1', 'companyOne', NULL, 'first1', 'last1', 'person1@companyOne.com', 'ADMIN', 'PRIVATE', 'M', 'password1')
INSERT INTO V_TABLE_USER VALUES(2,'person2', 'companyOne',NULL,'first2', 'last2', 'person2@companyOne.com', 'USER', 'PUBLIC', 'M', 'password1')
INSERT INTO V_TABLE_USER VALUES(3,'person1', 'companyTwo',NULL,'first3', 'last3', 'person1@companyTwo.com', 'ADMIN', 'PRIVATE', 'M', 'password1')
INSERT INTO V_TABLE_USER VALUES(4,'person4', 'companyTwo',NULL,'first4', 'last4', 'person4@companyTwo.com', 'USER', 'PUBLIC', 'M', 'password1')
Start the manager in the hsqldb demo directory and use these settings:
Type: HSQLDB IN-Memory (ie the first option)
Driver: org.hsqldb.jdbcDriver (ie the default option)
URL: jdbc:hsqldb:file:/temp/sampleDB
User: sa
Password (no password)
Hit 'OK' and you should see a database with one table, v_table_user.
Note that if you create an application to connect to the DB, you use the same values as above.
(Marilyn tried to fix formatting by removing code tags)
[ May 27, 2006: Message edited by: Marilyn de Queiroz ]
