Download HSQLDB 1.8 from the web site and replace the current hsqldb.jar file with it. JBoss 3.2.7 might also be shipping with this versoin.
Still the same after the upgrade...the file size still growing till i restart my JBOSS
Anything else i can do?
below is the properties file created once i start tomcat.
#HSQL Database Engine
#Fri Apr 29 18:15:43 SGT 2005
i'm trying with the mysql but it's 3-4 times slower, anyway to fine tune it...index oredi set to the TXID and TXOP field from JMS_Messages table
For 1.8, the file size will continue to grow until a certain point and then will be compacted automatically. You should not "run out" of space, although it may seem like it grows without bound.
I'm still experiencing this problem using JBoss 4.0.5 with the latest version of Hypersonic (18.104.22.168). My localDB.data is still growing out of control despite all the documentation that says otherwise.
If you have an issue with it, bring it up with the HSQL team.
It's not unusual to have it be > 1GB at times.