MQSeries.net :: View topic

vadivel · Posted: Wed Dec 05, 2007 4:33 pm Post subject:

Hi,

I'm using a Message Driven Bean with Bean managed transaction (as per our standard) and I use a non-XA datasource (simple Datasource) to log the message to a Database (There is no way we can use XADatasource and container managed Transaction on the bean

).

Now, once I get the message I have to do multiple table updates/inserts and if there is an error doing these db operations, the message has to be backed out to the Backout queue.

Will there be any issues if I open a new session for the backout queue JMSSender from the MDB and put the message there and commit the session? Or what is the correct way of doing it, I want my db operations to be rolled back but the JMSSender (to backout queue) to be committed if any db issue occurs while logging the message.

Thanks,
Vadivel