JBoss - Hypersonic Issue

BobK

For almost a month now, the hypersonic data file used by JBoss has been reaching the 2 gig maximum size on a daily basis. I have looked at my recent code changes, but nothing jumps out as a possible problem. Around the time that this started, we did move our MySQL database to another server, but I do not see how that would cause a problem. The activity on our system has gone up to over 100 concurrent users and several backgound processes running constantly. Could the amount of activity be the cause? Does anyone (support) know what JBoss stores in hypersonic that might give me a clue of what is causing the problem.

While researching this issue, I found the following at http://middlewaremagic.com/jboss/?p=89

JBoss ships Hypersonic SQL database with its installer by default, however in production environment it is not recommend to use Hypersonic as the database, hence it has to be switched with any of the supported databases and this article would help you to just do that in a step by step manner.

Anybody (Support) have any knowledge or comments about switching Hypersonic with another database?

Thanks

aware_support

We haven't been able to switch it off, but we haven't tried too much, so you may give it a go.

Also we are planning to release a version with JBoss replaced by Apache Active MQ (without persistence) - subject to testing. If you want to participate in testing of this version let us know. We do have 5.7-based version with Apache ActiveMQ already.