jboss7 comes with h2 already installed and setup. For hsqldb, just take h2 setup as example.

Following steps helps to setup hsqldb with jboss7.

A. create new jboss7 module: hsqldb module

1. first create directory $JBOSS_HOME/modules/org/hsqldb/main

   cd $JBOSS_HOME mkdir -p modules/org/hsqldb/main

2. download hsqldb and put the hsqldb.jar into created directory main

3. create into main directory following module.xml file (assuming hsqldb jar is hsqldb-x.x.x.jar)

B. setup hsqldb datasource

1. add hsql driver by editing $JBOSS_HOME/standalone/configuration/standalone.xml (locate drivers in standalone.xml file)

   ...

2. finally add hsqldb datasource in $JBOSS_HOME/standalone/configuration/standalone.xml (locate datasources in the file) we consider a file hsqldb database created into /home/hsqldb/data/witrHsqldb

   jdbc:hsqldb:file:/home/hsqldb/data/witrHsqldb hsqldb false false FailingConnectionOnly sa