jdbc2 persistencemanager + size of hypersonic DB

chrismay Jul 29, 2003 7:34 AM

We've recently moved our app. from JB 3.0.7 to 3.2.1, and are noticing some strange behaviour with the new default JMS persistence manager.

What seems to happen is that every JMS message results in a chunk of SQL being added to the server/default/data/hypersonic/default.script file. This never seems to get cleaned out, and is accumulating (for us) at a rate of tens of MB per hour.

Messages seem to be being delivered without any problems, though.

Is this file going to eventually clean itself up? If not, we will run out of disk space after a few days, so that's not good. If it's not going to clean up, is there any harm in our reverting back to the File-based PM ?

thanks,

Chris

1. Re: jdbc2 persistencemanager + size of hypersonic DB

doc_brown Sep 24, 2003 9:38 AM (in response to chrismay)

We're seeing this behavior too.

Is there anything to configure with regards to the default.script file?
Actions
2. Re: jdbc2 persistencemanager + size of hypersonic DB

doc_brown Sep 24, 2003 9:39 AM (in response to chrismay)

Oh, I forgot to mention: We're running 3.2.1 on Solaris with Java 1.3.1_07
Actions
3. Re: jdbc2 persistencemanager + size of hypersonic DB

stephanenicoll Sep 24, 2003 10:13 AM (in response to chrismay)

As 3.2.1, JBossMQ uses a JBCD persistence manager to the HSQL database. If you want the same behavior as 3.0.7 (I suppose it was file persistence) just change the persistence manager (check jbossmq-service.xml in deploy/jms)

Regards,

Stephane
Actions

Go to original post