This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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?
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.
Joined: Jul 24, 2003
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.
Joined: Jul 24, 2003
Originally posted by Wiley Snyder: HSQLDB
Is used to setup a demonstration or demo database that is setup within jboss quickly.
for sh*ts and giggles
If you want to use a production database you should consider finding one for jboss to use and that suits your particular projects needs.
I'm not talking about using it to store application data. I'm simply talking about the default setup of JBoss to use it to store the JMS messages.
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.