Add HyperSQL module to JBoss

This post is older than a year. Consider some information might not be accurate anymore.

This post explains how to create a hsqldb module for JBoss EAP.

Admin CLI

This CLI instruction will copy the JDBC jar into the created module folder. As dependencies the Java EE APIs are referenced.

module add --name=org.hsqldb.jdbcDriver \
 --resources=C:\Daten\lib\hsqldb.jar \
 --dependencies=javax.api,javax.transaction.api

Manual installation

Create the following module for HSQLDB under JBOSS_HOME/modules

+---org
      +----hsqldb
                +-----main
                      module.xml
                      hsqldb.jar

Contents of module.xml

<module xmlns="urn:jboss:module:1.0" name="org.hsqldb">
  <resources>
    <resource-root path="hsqldb.jar"/>
  </resources>
  <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
  </dependencies>
</module>

Copy the hsqldb.jar in the folder main. Configuration: Add in standalone.xml following datasource

<datasource jndi-name="java:/testHSQLMem" pool-name="testHSQLMem"
 enabled="true" use-java-context="true">
 <connection-url>jdbc:hsqldb:mem:test</connection-url>
 <driver>hsqldb</driver>
   <security>
    <user-name>sa</user-name>
<password></password>
   </security>
</datasource>
..
<drivers>
 <driver name="hsqldb" module="org.hsqldb">
   <driver-class>org.hsqldb.jdbcDriver</driver-class>
 </driver>
</drivers>