Right now we have configured a MQ listener notification to get and publish discrete messages to the broker from the MQ queue. The subsriber then inserts the records in these messages into a database table. Now we want to add a transaction bracket such either all of the DB inserts are successfull or none at all. So now the MQ publisher is publishing the MQ messages in a group to the MQ queue.
How can i use the MQ listener notification so that webmethods can retrieve all of the messages successfully or none at all? What is the best mechanism to add a transaction bracket in this case?
Or Should i just use a GET service in a loop and do explicit transaction handling (startTransaction, closeTransaction, rollbackTransaction etc…)?