aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Multi-database JMS Queues" Watch "Multi-database JMS Queues" New topic
Author

Multi-database JMS Queues

Steven Landers
Ranch Hand

Joined: Nov 02, 2008
Posts: 30
Hello-

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.

Thanks,
Steven






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
author
Bartender

Joined: May 14, 2008
Posts: 5836
    
    7

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Multi-database JMS Queues