What are your thoughts on using HSQLDB in production. We recently had some people from our office take a class that was taught by someone from JBoss. This person flat out told them that they should NOT use HSQLDB in production. If I'm not mistaken doesn't JBoss use HSQLDB to store its JMS queue?
Originally posted by Henk O: Don't use hsqldb in production. We found it out the hard way when using JMS. We even had JBoss lock up entirely a few times. Now we're using oracle and everything runs smoothly.
So you're using Oracle over the network for your JMS queue? My concern was that we would notice a performance hit if we had to write all of our JMS stuff over the network as opposed to in memory on the server as is the case when using HSQLDB.
We use Oracle for all of our normal application data.
One of my clients had serious issues with using the default HSQLDB for storing JMS messages. There were alll kinds of timeouts because HSQLDB isn't production-quality. It didn't seem to handle high volumes/concurrency very well. I would suggest using a better DBMS for storing JMS messages in production. Oracle, Sybase, SQL Server, Postgres, MySQL, <add-yours>, will all do nicely.
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop