The compute node only has a Transactional Mode for Automatic/Commit. There
is a checkbox for throwing an exception for a Database error,but in my case
I wouldn't get it directly because the stored procedure is wrapping the SQL
calls.
So, the stored procedure could succeed even though in it an insert failed.
To the compute node the call to the stored procedure succeeded so no
exception would be created. Now, if the call in the compute node failed
because it couldn't access the stored procedure due to permissions than a
database exception would occur and the failed terminal wiring would be
activated. Otherwise it would go back to the beginning of the flow, i.e.
MQInput Node.
Arg!!!
Thanks,
Chris
|---------+----------------------------->
| | "Robert Broderick"|
| | <[EMAIL PROTECTED]|
| | OTMAIL.COM> |
| | Sent by: "MQSeries|
| | List" |
| | <[EMAIL PROTECTED]|
| | .AC.AT> |
| | |
| | |
| | 09/19/2003 01:23 |
| | PM |
| | Please respond to |
| | "MQSeries List" |
| | |
|---------+----------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: WMQI v2.1 CSD 5 - Commit for message flow question
|
|
|
>------------------------------------------------------------------------------------------------------------------------------|
Just a question so stay out of my throat!!! (tee hee hee)
In the compute node, without actually looking, is there the setting for
throwing the exception or handleing it from the database and what is
checked???? (That option may only be on a DB node).
bb
>From: Christopher Fryett <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: WMQI v2.1 CSD 5 - Commit for message flow question
>Date: Fri, 19 Sep 2003 11:32:40 -0500
>
>When doing SQL stored procedures in a Compute Node should a throw force a
>rollback, as the documentation seems to leave one to believe or is it
>required to do a RETURN and use a Filter Node to force a rollback?
>
>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
_________________________________________________________________
Fast, faster, fastest: Upgrade to Cable or DSL today!
https://broadband.msn.com
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
