Hi,
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.
Regards,
Hiram