[JBoss-user] [Messaging, JMS & JBossMQ] - Re: Caching messages in Hypersonic database
The HSQDB database file won't shrink until you do a clean ashutdown. What is the stack trace of the OOMException? If you want to continue using HSQLDB, I would use 1.7.2 (which is in 3.2.7RC I believe, or d/l the .jar file from the website.) Otherwise, I suggest going with a free database like Postgres or MySql, especially if your data is large. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3855285#3855285 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3855285 --- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - Re: Caching messages in Hypersonic database
Hi, Thanks for the quick reply. I've noticed the I had an error in my previous post - I use a topic, not a queue. I did what you wrote (removed all messages), but the size of the file stayed the same. Is it because it was already alocated, and it will not insert new messages to the same space, or did I do something wrong? Thanks, Ziv View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3855097#3855097 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3855097 --- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - Re: Caching messages in Hypersonic database
Messages are stored by default in the DB when they are added to the server. The limit for HSQLDB is 2GB per table (or DB?). The message cache controls which messages are kept in memory, and the messages remain in the database when removed from memory JBoss. Increasing the size of your memory won't increase the size allowed by HSQLDB. You can delete messages by clearing each message queue through JMX. What is the stack trace of the OOMException? You either need to remove messages or use a different database (like MySQL). View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3854683#3854683 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3854683 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user