Get a javax.sql.DatasSource via JNDI, I guess "java:/localDB". Then get a connection, issue "CHECKPOINT DEFRAG", close the connection, etc. HSQL also issues this command after ever 200MB is inserted. This won't damage your data, but as I said will cause JMS to block.
Again, try to upgrade to 1.7.2 which will be part of 3.2.6. (Rember to back-up your data.) Also, if you're still having trouble you can also get help from http://sf.net in the HSQL forum. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3848255#3848255 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3848255 ------------------------------------------------------- This SF.Net email is sponsored by: thawte's Crypto Challenge Vl Crack the code and win a Sony DCRHC40 MiniDV Digital Handycam Camcorder. More prizes in the weekly Lunch Hour Challenge. Sign up NOW http://ad.doubleclick.net/clk;10740251;10262165;m _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
