HSQLDB 1.7

[mkarrys]

Can someone tell me how to replace hsqldb 1.6 with hsqldb 1.7. Is it possible to just replace hsqldb.jar? When I do this I cannot connect to the datbase anymore and it does not recreate the databases under db/hypersonic but it does recreate the db/hypersonic directories. In the jboss source it says the the hsqldb was patched. Can someone tell me what was patched?

[cosmic_crusader]

Check out:

https://sourceforge.net/tracker/index.php?func=detail&aid=587623&group_id=22866&atid=376687

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).

[dheeraj_s]

Hi
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.

Cheers

Dheerah

[dheeraj_s]

Hi
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.

Cheers

Dheeraj