In our project we are using JBOSS 4.0.5. We have replaced hsql db with mysql 5.0. During the course of execution the table jms_messages keeps growing almost 500,000 records per day. All the messages getting published are non-persistent and messages are non- durable.
Could you please let us know as to why the size of the table jms_messages keeps on growing amd how do we control this? We have also observed that once the publishing to the topic stops the table jms_messages gets cleaned up. However in an application running in the Production environment the publishing will never stop.
Can you take a look at the JMX console for the Message Cache MBean and post the information from this MBean here?