| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Stored Procedure Call and Unit of Work ! |
« View previous topic :: View next topic » |
| Author |
Message
|
| Fady |
 Posted: Sun Jan 26, 2003 1:42 am Post subject: Stored Procedure Call and Unit of Work ! |
 |
|
Novice
Joined: 15 Jan 2003
Posts: 15
Location: Egypt , KSA
|
I need to call a stored procedure in DB2 or Oracle in my flow and in the same time Grantee the Unit or work which mean in case of Flow Failure all the transactions executed in the Stored procedure are rolled back.
Can i do somthing like that , or i have to write the Reverse Sotred procedure in case of failure ?!
thank you |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Jan 27, 2003 8:58 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Yes, you can do this by configuring MQSeries to act as a Global Transaction Coordinator. Please do a search in this form for 2 phase commit and you will see many threads related to this topic.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| jbacskai |
| Posted: Fri Jan 31, 2003 12:58 am Post subject: |
|
|
Apprentice
Joined: 30 Dec 2002
Posts: 26
Location: Hungary
|
Hi,
You can find very usefull documentation of this topic in the SG24657900 Redbook!!! (Developing Solution in Websphere MQ Integrator)
JBacskai |
|
| 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
|
|
|
|
