| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| transactions in message flow |
« View previous topic :: View next topic » |
| Author |
Message
|
| venky |
 Posted: Fri May 02, 2008 11:48 am Post subject: transactions in message flow |
 |
|
Master
Joined: 08 Jul 2003
Posts: 205
|
Hi All,
The requirement is that the flow has to interact with several stored procedures in a sequence and depending on the response from each of the stored procedures invoke the next one. Finally consolidate the response and send it back to a queue.
if there is a failure in one of the stored procedures, we have to rollback the entire transaction.
is XA the only solution for this? For me to use XA, can I use ESQL, or is Java the only option? is there any good reference/link to understand WMB XA.
If someone has designed something like this before please share your experience.
V |
|
| Back to top |
|
 |
| EAI Developer |
| Posted: Fri May 02, 2008 12:26 pm Post subject: |
|
|
Centurion
Joined: 30 Nov 2005
Posts: 101
Location: US
|
First of all,what is your question  . I didn't see any explanation of the problem here in your post.
Regards,
EAI Developer. |
|
| Back to top |
|
|
| niraj |
| Posted: Mon May 05, 2008 11:13 pm Post subject: |
|
|
Newbie
Joined: 30 Apr 2008
Posts: 6
Location: Bangalore
|
V,
I dont see a problem here at all...
You can either call all the SP's in a single compute node or across your Message Flow. In case the SP fails, just raise an exception and the entire thing will roll back.
This is how it's supposed to happen in WMB.
Was this the issue - ir did we miss a point?
~Niraj |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
