How to store JMS messages permanently in the database

[vk.iyengar]

After consumer/subscriber acknowledge, I would like to store the message permanently in the oracle database. This is one of my business requirement where we want to replay the message. When i say replay means messages from the database will be put back into Queue for processing again.

Thanks

[genman]

Meaning, you don't want the messages deleted upon acknowledgement?

It might be easiest with Oracle to simply have a trigger upon delete that copies the data to a second table.

You can theoretically alter the persistence manager, since the class is pluggable to do the same.

[genman]

Also, using pure JMS, you could "add" this message to another queue when consuming from the original queue.