| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Two Phase Commit |
« View previous topic :: View next topic » |
| Author |
Message
|
| x061294 |
 Posted: Sun May 13, 2007 3:37 pm Post subject: Two Phase Commit |
 |
|
Acolyte
Joined: 05 Apr 2005
Posts: 62
|
I have two web service call's that I need to make out of broker, each that would update a DB. I want to run the whole thing under 1 transaction, and be able to commit/rollback as needed if they both work or one or the other fails. Normally doing two phase commit, using WebSphere MQ as the Transaction Manager, I understand the ability to do two phase commit with making ODBC calls into a DB and writing to a queue, etc, all within 1 transaction. But, with WS call's to two different machines that update different databases, is this something in scope?
If not in scope for WebSphere MQ / WMB in an XA transaction, is it possible that the WS-xx spec's (WS-Coordination, WS-AtomicTransaction, WS-BusinessActivity) would be in play? If so, has anyone used them within a WS transaction from the Broker?
Looking for anyone's thought's/opinions on this. Another option I suppose would be to use something like WebSphere Process Server as a business transaction, but, I don't know the impact of that, and, if that just would wrap a more manual process around the commit/rollback. |
|
| Back to top |
|
 |
| marcin.kasinski |
| Posted: Sun May 13, 2007 10:39 pm Post subject: Re: Two Phase Commit |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
|
| Back to top |
|
|
| x061294 |
| Posted: Mon May 14, 2007 3:47 am Post subject: |
|
|
Acolyte
Joined: 05 Apr 2005
Posts: 62
|
I had read about that. I guess my question was, is there anything in WMB that would support a distributed two phase commit like this across Web Services, or is it something that I would have to build using the framework of the WS-xx spec's?
And if not in WMB, which would be my preferred, but is there something out of the box in WebSphere Process Server that would do this? Process Server is designed for longer running transactions, I'm not familiar enough with it to know if it can support transactional integrity across multiple parts of the transactions such as multiple web services, or if it handles that type of integrity through compenesating transactions. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon May 14, 2007 1:18 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| x061294 wrote: |
I had read about that. I guess my question was, is there anything in WMB that would support a distributed two phase commit like this across Web Services, or is it something that I would have to build using the framework of the WS-xx spec's?
And if not in WMB, which would be my preferred, but is there something out of the box in WebSphere Process Server that would do this? Process Server is designed for longer running transactions, I'm not familiar enough with it to know if it can support transactional integrity across multiple parts of the transactions such as multiple web services, or if it handles that type of integrity through compenesating transactions. |
You will most probably have to go for compensating transactions...
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| x061294 |
| Posted: Tue May 15, 2007 4:41 am Post subject: |
|
|
Acolyte
Joined: 05 Apr 2005
Posts: 62
|
| That's what I was afraid of. If anyone know's of anything else, appreciate any feedback. |
|
| 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
|
|
|
|
