-
1. Re: Caching messages in Hypersonic database
genman Nov 10, 2004 4:43 PM (in response to topatidle)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). -
2. Re: Caching messages in Hypersonic database
topatidle Nov 14, 2004 4:56 AM (in response to topatidle)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 -
3. Re: Caching messages in Hypersonic database
genman Nov 15, 2004 6:16 PM (in response to topatidle)
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.