Page History

...

This application is using the HSQL database that comes as part of the JBoss bundle. Open the hsqldb-ds.xml file located in the <jboss_home>/server/<your_server_name>/deploy directory and which sets up the default datasource. Near the top of the file, look for the <connection-url> element. Make Uncomment this element and make sure the value is set to jdbc:hsqldb:hsql://localhost:1701 and that any other connection-url elements are commented out.
Add the following SQL statement to the top of <jboss_home>\server\default\data\hypersonic\localDB.script (Jboss must be stopped before you edit the file).

CREATE MEMORY TABLE CUSTOMER(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(45),BIRTHDATE DATE,SSS_NO VARCHAR(25),ADDRESS VARCHAR(60),ANNUAL_SALARY DOUBLE,LOAN_AMOUNT DOUBLE).

...