The application is getting a message via MQSeries. The message is supposed to be parsed and persisted into the database and there are multiple tables to be updated.

If there is a problem and rollback occurs, the database is ok b/c it is part of the transaction but I lose the message from MQ. Is there a way to make the MQ message part of the transaction so if the db transaction fails than the message goes back into MQ?

Thanks in advance for your insights.