my dog learned polymorphism*
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
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: 5812

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
It is sorta covered in the JavaRanch Style Guide.
subject: Multi-database JMS Queues
Similar Threads
jboss 4.0.5 clustering issue [renamed]
Cant get reference to Queue
JMS topic and queue
setRedliverDelay in Jboss 4.0.4 GA - JMS
Remove "queue" prefix from JMS jndi name