Category Archives: hsqldb

setup hsqldb with jboss7

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

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