Author |
Message
|
phanish |
Posted: Fri Jun 07, 2013 11:25 am Post subject: rolling back the messages from queue |
|
|
 Apprentice
Joined: 04 May 2013 Posts: 30
|
Hi All,
I have a requirement like I have to write multiple messages to a queue.This part I am handling in Data Power. when the request comes to Data Power with multiple contracts(for eg) I am making a query call for each contract and building the message for each contract(if it is success after database query) and writing it to a queue. If there is any failure in any of the contract during query call or during validation I have to roll back already placed messages in the queue. Could you please suggest me how to implement this. Thanks in advance. |
|
Back to top |
|
 |
Vitor |
Posted: Fri Jun 07, 2013 11:33 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
I don't know much about DataPower, but in a normal application I'd put all the messages in the same UoW and only commit it when I was done. _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
phanish |
Posted: Fri Jun 07, 2013 12:02 pm Post subject: |
|
|
 Apprentice
Joined: 04 May 2013 Posts: 30
|
could you please elaborate on how to Commit. Do we have to set any PMO. |
|
Back to top |
|
 |
Vitor |
Posted: Fri Jun 07, 2013 12:20 pm Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
phanish wrote: |
Do we have to set any PMO. |
The word you need to research is SYNCPOINT _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
phanish |
Posted: Fri Jun 21, 2013 9:50 am Post subject: |
|
|
 Apprentice
Joined: 04 May 2013 Posts: 30
|
using pmo option SYNCPOINT and setting UoW as 1,I am able to commit and roll back the messages. But I have a confusion whether to use SYNCPOINT everytime we are writing messages to queue or only for the first time. |
|
Back to top |
|
 |
bruce2359 |
Posted: Fri Jun 21, 2013 12:44 pm Post subject: |
|
|
 Poobah
Joined: 05 Jan 2008 Posts: 9469 Location: US: west coast, almost. Otherwise, enroute.
|
Each MQPUT allows you to specify if the message is to be _SYNCPOINT or NO_SYNCPOINT. Same with MQGET.
As suggested earlier, research mq+syncpoint. _________________ I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
Back to top |
|
 |
|