The process flow requires that a message read from a queue is delivered to a target database only once. In the event of DBMS operation failure, the message should be put back. How can you accomplish this in the most reliable fashion ?
Receive a message using Client Acknowledgement; when a database operation is successful,acknowledge the message as processed; on DBMS failure, complete the process without Acknowledgement.
