| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database Insert Rollback |
« View previous topic :: View next topic » |
| Author |
Message
|
| Rockon |
 Posted: Thu Nov 03, 2005 1:40 pm Post subject: Database Insert Rollback |
 |
|
Apprentice
Joined: 24 May 2004
Posts: 43
|
Hi All,
Had an issue wherein I am not able to rollback database inserts in a flow even when the message fails to make it to the Output queue.
Scenario:
InputNode->ComputeNode A->OutputNode
The test message is an order message for 100 parts init.Say in the table I insert 77 parts and while processing the 78th part the message fails.The failed message((complete) is received in the failure queue but the rollback in the table does not occur for the previous 77 parts.
Properties set in the Compute Node A: Transaction Mode =Automatic
Throw exception in Database error= Checked
InputNode:Transation Mode=YES
OutputNode:Transation Mode=YES
p.s Database insert is normal esql insert statement(as in not using PASSTHRU function)
I appreciate any inputs with this regard.
Thankyou,
Cheers |
|
| Back to top |
|
 |
| JT |
| Posted: Thu Nov 03, 2005 2:47 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
What is the database platform?
What is the message broker platform, z/OS ?
Did you set up the XA Resource Manager definitions ? |
|
| Back to top |
|
|
| fschofer |
| Posted: Thu Nov 03, 2005 11:47 pm Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
| Rockon |
| Posted: Fri Nov 04, 2005 8:28 am Post subject: |
|
|
Apprentice
Joined: 24 May 2004
Posts: 43
|
Hi,
Platform: OS:Windows 2000 ;DB :Oracle 9.0.5 ;
How is the exceptions handled ?We are not processing exceptions.i.e. the catch terminal of the input node is wired to trace node which is followed by a throw node.
The failure terminal of the input node is pointing to another trace node followed by a Failure queue.
So basically its a simple setup.
Please let me know if i can provide you with any other details.
Thankyou for your inputs so far,
Cheers |
|
| Back to top |
|
|
| Rockon |
| Posted: Fri Nov 04, 2005 6:16 pm Post subject: |
|
|
Apprentice
Joined: 24 May 2004
Posts: 43
|
| Resolved.....had to wire the catch terminal of the input queue to a trace node followed by a throw node....thankyou for all your inputs..cheers |
|
| 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
|
|
|
|
