jeffdo - Really a HSQL and not JBossMQ question, but you can run that statement as SQL command and it sets it within the file. Create a fix.bsh script that accesses the DataSource and runs the SQL command.
from where do i execute the command CHECKPOINT DEFRAG. We are using Jboss 4.0.5.GA and the data file grows till 2GB after which it throws the exception
"org.jboss.mq.SpyJMSException: Could not store message: 2626268 msg=48627 hard NOT_STORED PERSISTENT queue=TOPIC.JECCommand.ID:6.-2147483648 priority=4 lateClone=false hashCode=29761546; - nested throwable: (java.sql.SQLException: S1000 Data file size limit is reached in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)])"
any help will be highly appreciated.