| Author |
Message |
 Topic: How to rollback multiple table inserts in a Compute node |
prak
Replies: 7
Views: 5446
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Sep 06, 2002 5:24 pm Subject: How to rollback multiple table inserts in a Compute node |
Here is the message flow (simplified):
MQInput 1-->Compute Node C1-->Custom Node CN2--> Custom Node CN3-->TryCatch 1 [Try]-->Compute Node C4 [out] --> MQOutput 1 ... |
| Topic: How to rollback multiple table inserts in a Compute node |
prak
Replies: 7
Views: 5446
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 04, 2002 4:03 pm Subject: How to rollback multiple table inserts in a Compute node |
Kiran,
The DB version I am using is DB2 7.1.
However, doesn't your sugestion imply a complete Message Flow Rollback?
As I mentioned in my addendum, I only want to rollback database transactio ... |
| Topic: How to rollback multiple table inserts in a Compute node |
prak
Replies: 7
Views: 5446
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 02, 2002 9:22 pm Subject: How to rollback multiple table inserts in a Compute node |
Addendum to the above:
The Compute Node in which we are doing the datasbae updates appears after MANY other nodes doing other things in the message flow.
So, I don't want the WHOLE mesage flow t ... |
| Topic: How to rollback multiple table inserts in a Compute node |
prak
Replies: 7
Views: 5446
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 02, 2002 9:16 pm Subject: How to rollback multiple table inserts in a Compute node |
I have a Compute node wired to the Try terminal of a Try-Catch Node.
In the Compute Node, I am using "passthru" to insert data into multiple DB2 tables. If an insert in a particular table fails, I ... |
| Topic: Java and MQ Triggering |
prak
Replies: 3
Views: 2670
|
Forum: IBM MQ Java / JMS Posted: Tue Jul 16, 2002 9:49 am Subject: Java and MQ Triggering |
I have a simple Java program that puts a message on an application Q using WriteUTF. I used the provided sample MQ Java prgram as my template.
For some reason, the trigger attached to the Q is not ... |
| Topic: How can one do the following message "replication" |
prak
Replies: 6
Views: 2941
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 14, 2002 8:24 am Subject: How can one do the following message "replication" |
| One way that I came up with is to have the first Compute node produce two identical output messages using PROPOGATE. The node also adds an extra "destination" element to the two messages that denotes ... |
| Topic: How can one do the following message "replication" |
prak
Replies: 6
Views: 2941
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 14, 2002 8:07 am Subject: How can one do the following message "replication" |
Sorry if this is a dumb question:
I have a Compute node that produes an output message.
I want this message to go to an MQOutput node so that it can proceed to an output MQ queue.
At the same ... |
| Topic: Exception Creation and Handling in MQSI |
prak
Replies: 1
Views: 4142
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Apr 28, 2002 12:51 pm Subject: Exception Creation and Handling in MQSI |
I figured it out myself.
ComputeNode1 should have the following ESQL:
IF SQLState1 <> '00000' then
THROW USER EXCEPTION MESSAGE 2950 VALUES (....);
end if;
Earlier I was comparing SQ ... |
| Topic: Exception Creation and Handling in MQSI |
prak
Replies: 1
Views: 4142
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Apr 27, 2002 12:13 pm Subject: Exception Creation and Handling in MQSI |
Hi..
I am using MQSI 2.1 in WIn 2k with DB2 7.2
I've read all the info about handling database errors and creating user exceptions using a Try-Catch and ExceptionLists but it is just not workin ... |
