jQuery in Action, 3rd edition
The moose likes JBoss/WildFly and the fly likes Multi-database JMS Queues Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Multi-database JMS Queues" Watch "Multi-database JMS Queues" New topic

Multi-database JMS Queues

Steven Landers
Ranch Hand

Joined: Nov 02, 2008
Posts: 30

JBoss version = 4.0.4

I have an odd requirement to use Hypersonic for some Queues, and PostgreSQL for other queues. This is a different requirement from simply 'switching from Hypersonic' because some queues will still use hypersonic. Essentially the client wants to have a 'local queue' (hypersonic) and a 'global queue' (ha-jndi singleton, postgres).

Is this possible? I've tried simply creating a 2nd Destination Manager and pointing to it, but it doesn't seem to work. When I do this, the uil2 service streams debug messages startup, and jboss never loads.

Global Q /deploy-hasingleton/jms/globalqueue-service.xml (postgres)

Local Q /deploy/jms/localqueue-service.xml (hypersonic)

I also have the postgres-jdbc-state-service.xml and postgres-jdbc2-service.xml in the /deploy-hasingleton/jms directory, and left the HSQL ones in the /deploy/jms directory. I can get everything working on ALL postgres or ALL hypersonic, just not both currently.

Additionally, this is constantly spilled into the server.log

If I change DestinationManager to point at PostgresSql, or change PostgresDestinationManager to DestinationManager, everything works...just on one database, however.

Any thoughts? Things to try? It would be nice if I could affirmatively say "JMS Queues on a JBoss server CANNOT be split amongst 2 databases via configuration" - but at this point, it seems like it may still be possible.


Steven Landers
Ranch Hand

Joined: Nov 02, 2008
Posts: 30
Correction: JBoss does load, but I get this in my application log:

When I point the DestinationManager to Postgres or Hypersonic only, then it works. Thoughts?
Steven Landers
Ranch Hand

Joined: Nov 02, 2008
Posts: 30
If this is ridiculous - If I could have a few key reasons so I can explain away this issue and avoid this multi-db-Q nonsense, I'd be very appreciative.
Peter Johnson

Joined: May 14, 2008
Posts: 5852

As far as I know, you can set up JBoss Messaging to use only one database. Messaging stores more than just messages in the database.

JBoss In Action
wood burning stoves
subject: Multi-database JMS Queues
jQuery in Action, 3rd edition