Re: WMQI v2.1 CSD 5 - Transactional Rollback
Chris:
Thank you for your insightful help. We still had a few problems, but this
is the resolution to our problem:
1. The MQInput node only had the out terminal wired.
2. The Compute node which called the 1-n SQL stored procedures
reviewed the return codes and if it was an error it threw a user exception
which forced the failure terminal on the compute node to become active.
3. We then constructed our error message, wrote it to an output
error queue, and threw an exception to cause a transactional rollback
4. The error queue would be handled by another flow which would
update an error table with the proper content
5. The MQInput node's queue backout count was set to 1 so the
message would be thrown
After extensive testing transactional rollback occurred.
So, in summary would someone please put the ability to call
COMMIT/ROLLBACK in a message flow so I don't have to jump through hoops
again, arg!
Thank you for your help.
Regards,
Chris & Satish
|-+>
| | "Christopher |
| | Frank" |
| | <[EMAIL PROTECTED]|
| | COM> |
| | Sent by: |
| | "MQSeries List" |
| | <[EMAIL PROTECTED]|
| | n.AC.AT> |
| ||
| ||
| | 09/23/2003 03:09 |
| | PM |
| | Please respond to|
| | "MQSeries List" |
| ||
|-+>
>--|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: WMQI v2.1 CSD 5 - Transactional Rollback
|
|
|
>--|
Chris,
>>>No, I mean that a transactional rollback will occur first,
>>>i.e. any inserts will be removed from a database, and then
>>>the failure terminal will kick in.
In WMQI the scope of a transaction is the message flow. That would include
actions taken on any failure paths.
Can I ask what action(s) are you taking on the failure path that cannot be
performed before the rollback occurs? It is possible to have the failure
path actions outside of the transaction, but they will still be executed
before the transactional rollback occurs.
Regards,
Christopher Frank
Sr. I/T Specialist - IBM Software Group
IBM Certified Solutions Expert - Websphere MQ & MQ Integrator
Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008
e-mail: [EMAIL PROTECTED]
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: WMQI v2.1 CSD 5 - Transactional Rollback
Chris, >>>No, I mean that a transactional rollback will occur first, >>>i.e. any inserts will be removed from a database, and then >>>the failure terminal will kick in. In WMQI the scope of a transaction is the message flow. That would include actions taken on any failure paths. Can I ask what action(s) are you taking on the failure path that cannot be performed before the rollback occurs? It is possible to have the failure path actions outside of the transaction, but they will still be executed before the transactional rollback occurs. Regards, Christopher Frank Sr. I/T Specialist - IBM Software Group IBM Certified Solutions Expert - Websphere MQ & MQ Integrator Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008 e-mail: [EMAIL PROTECTED] Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: WMQI v2.1 CSD 5 - Transactional Rollback
No, I mean that a transactional rollback will occur first, i.e. any inserts
will be removed from a database, and then the failure terminal will kick
in.
Thank you,
Chris
|-+>
| | "Christopher |
| | Frank" |
| | <[EMAIL PROTECTED]|
| | COM> |
| | Sent by: |
| | "MQSeries List" |
| | <[EMAIL PROTECTED]|
| | n.AC.AT> |
| ||
| ||
| | 09/23/2003 11:48 |
| | AM |
| | Please respond to|
| | "MQSeries List" |
| ||
|-+>
>--|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: WMQI v2.1 CSD 5 - Transactional Rollback
|
|
|
>--|
Chris,
>>>Does transactional rollback occur when the MQInput node's
>>>failure terminal is wired, but the catch terminal is not?
If by rollback you mean will control pass down the failure path, the answer
is Yes.
Regards,
Christopher Frank
Sr. I/T Specialist - IBM Software Group
IBM Certified Solutions Expert - Websphere MQ & MQ Integrator
Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008
e-mail: [EMAIL PROTECTED]
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: WMQI v2.1 CSD 5 - Transactional Rollback
Chris, >>>Does transactional rollback occur when the MQInput node's >>>failure terminal is wired, but the catch terminal is not? If by rollback you mean will control pass down the failure path, the answer is Yes. Regards, Christopher Frank Sr. I/T Specialist - IBM Software Group IBM Certified Solutions Expert - Websphere MQ & MQ Integrator Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008 e-mail: [EMAIL PROTECTED] Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
WMQI v2.1 CSD 5 - Transactional Rollback
Fubar! I need your help in answering a simple question about transactional rollback in WMQI v2.1 CSD 5. Does transactional rollback occur when the MQInput node's failure terminal is wired, but the catch terminal is not? Chris Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
