| Author |
Message
|
| mar |
 Posted: Wed May 04, 2005 5:20 am Post subject: mqseries + MTS |
 |
|
Apprentice
Joined: 18 Oct 2004
Posts: 26
|
Hi. Could anyone please help me on this:
I have a COM+ component which gets the messages of a queue in a loop, it processes every ot them and commits until it finds some problem where it rollbacks and ends.
As much I know, MTS every time it commits, it transfers the checkpoint so if it rollbacks, it will rollback only after the time of the last commit. What I see here is that when I rollback, it rollbacks all the previous messages of the queue without considering the commits that took place.
I use syncpoint option in Get options and contextutil.Setcomplete to commit according to theory.
Please help.
Thanks in advance.  |
|
| Back to top |
|
 |
| OddDuck |
| Posted: Fri May 06, 2005 11:44 am Post subject: |
|
|
Newbie
Joined: 09 Mar 2005
Posts: 2
|
I'm not sure that MQ participates in a COM+ transaction. Your scenario seems to lend credence to it not participating. You might want to try Qmgr.Commit after you have finished processing each message. It really depends on what the unit of work is and where you need to rollback to in the event of a problem.
Perhaps someone else out there knows for sure.
I thought I was the only person in the world doing COM+ and MQ. Proven wrong again. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri May 06, 2005 12:31 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
MQ works with MTS only if you are using the .NET interface....
 |
|
| Back to top |
|
|
| mar |
| Posted: Mon May 09, 2005 12:39 am Post subject: |
|
|
Apprentice
Joined: 18 Oct 2004
Posts: 26
|
Hi. Thanks for answering me.
I am using COM+ components written in VB.NET.
I cannot use local transactions by using qmgr.commit / qmgr.Backout because I have MTS controlling the transactions.
Can anyone please help?
Thanks in advance. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon May 09, 2005 12:11 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Read the .NET manual. It should explain how to coordinate a transaction through MTS. You might of course have additional problems with security and username running the com+ component...(think impersonation)...
 |
|
| Back to top |
|
|
| mar |
| Posted: Mon May 09, 2005 11:33 pm Post subject: |
|
|
Apprentice
Joined: 18 Oct 2004
Posts: 26
|
Thanks for replying me.
I don't have problems with security on COM. I can call the components without any access denied errors. My problem is that although I commit on every message when I rollback all the messages are rollbacked. (pls read description in my fisrt message).
You are refering to a .NET maual. The one I have does not mention anything on mqseries + MTS. What is the title of the manual you are refering to?
Thanks in advance. |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Tue May 10, 2005 5:13 am Post subject: |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
I believe he means the IBM Using .Net manual (GC34-6328-02) but there is also a red book that is pretty useful WebSphere MQ Solutions in a Microsoft .Net Environment (SG24-7012-00)
Hope this helps. |
|
| Back to top |
|
|
| JohnGee |
| Posted: Fri May 20, 2005 1:17 pm Post subject: |
|
|
Newbie
Joined: 07 Apr 2005
Posts: 8
|
Any progress??? Better late then never, but here is what I can add. WebsphereMQ uses an XA compliant module to work with MTS/COM+. Though your app needs to run on the server or a transactional client (both cost the same for some reason) in order to join the transaction. It seems your MQ work was able to join the transaction, but didn't really play nicely in the end. Did you know you need to register the MQ XA module on the 2003 server? Look at this: http://support.microsoft.com/?id=817066
I have seen MQ work commit and rollback with COM+ transactions. |
|
| Back to top |
|
|
| kimmyj |
| Posted: Wed Jun 15, 2005 9:42 am Post subject: |
|
|
Novice
Joined: 26 Jun 2003
Posts: 19
Location: UK
|
| So does this XA stuff also work with the Biztalk Adapter for MQ? |
|
| Back to top |
|
|
|
|
