I just added a new JDBC PersistenceManager/CacheStore. It's better than the original, It:
- does not need the NoTransDS anymore. - All SQL statements are configurable - Supports restoring the same queue multiple times. (so that you can deployed and undeployed a queue multiple times) - Easier on memory usage. - CacheManager does not need to do a 2nd write to store messages that have alleady been stored in the DB. - It works out of the box with hypersonic sql.
It's been commited to the CVS head branch... Anybody brave enough to give it a try. If you do, just look at the jbossmq-service.xml file, and follow the directions listed in the JDBC PM section.