• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HSQLDB in production?

 
Frank Malinowski
Ranch Hand
Posts: 30
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 30
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 30
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 67
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic