ramprasad madathil wrote:Put this whole stuff - receiving msg from the queue, procedure call and posting to a topic in a transaction? If any one fails, everything is rolled back.
In below two approaches which one is better?
(1) To create CLIENT_ACKNOWLEDGE session as :
Here I will acknowledge message only after the successful completion of transactions(stored procedures)
(2) To use transacted session i.e., connection.createSession(true, -1). In this approach because of some exception in transaction (stored procedure) the message is rolled back and Redelivered. They are rolled back again and again and continue until I kill the program. Can I limit the number of redelivery of jms messages from queue?