wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes HSQLDB in production? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "HSQLDB in production?" Watch "HSQLDB in production?" New topic
Author

HSQLDB in production?

Frank Malinowski
Ranch Hand

Joined: Jul 24, 2003
Posts: 30
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?

This seems to be a contradiction.

Frank
Henk O
Greenhorn

Joined: Jul 15, 2005
Posts: 4
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.
Frank Malinowski
Ranch Hand

Joined: Jul 24, 2003
Posts: 30
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.

Frank
Frank Malinowski
Ranch Hand

Joined: Jul 24, 2003
Posts: 30
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.

Frank
Tom Marrs
Author
Ranch Hand

Joined: Sep 20, 2000
Posts: 67
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.

Tom
 
jQuery in Action, 2nd edition
 
subject: HSQLDB in production?
 
Similar Threads
Is JBoss free?
JBOSS MQ Persistence on Oracle
Question : Pure Java Databases
Need help urgent
Mckoi vs HSQLDB