I'd love to see this patch applied to JBoss3 and include HSQLDB 1.7 with the official releases.
I need HSQLDB 1.7 or otherwise I get connection lost errors from JBoss. (not sure on what triggers that but it works fine with HSQLDB1.7 or MySQL ... I'd prefer to use HSQLDB as it is cross platform).
Thanks for the Link. I copied HypesonicDatabase.java from the link, complied and made my own hsqldb-plugin.jar. Download hsdb1.7.1 add this jar and hsqldb.jar in the lib and run. You shall be able to see the hsdb1.7.1 running.
There is one more way to get away with this kind of problem. Run your hssqdb seperatly and on any port.
Go to hsqldb-service.xml
<config-property name="ConnectionURL" type="java.lang.String">jdbc:hsqldb:hsql://localhost:7373</config-property>
Change the port address to the one at which HSQLDB is running. JBoss still starts HSDBQL at default 1476 port but don't use it.