| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Transaction Mode setting in compute node |
« View previous topic :: View next topic » |
| Author |
Message
|
| Amith |
 Posted: Wed Feb 23, 2005 4:59 am Post subject: Transaction Mode setting in compute node |
 |
|
Novice
Joined: 26 Nov 2003
Posts: 21
Location: india
|
Hi all,
I am trying to update several tables one by one present in DB2 database from a compute node.
My problem is when i update table1 and table2 and if i get an error while updating table3, the changes made to table1 and table2 are not getting rolled back. I have set Transaction Mode to "Automatic".
i am running on MQSIv2.1 with CSD5
DB2 v8.1
MQSeries V5.3 with CSD4
Plese help me with this. |
|
| Back to top |
|
 |
| Craig B |
| Posted: Wed Feb 23, 2005 5:23 am Post subject: |
|
|
Partisan
Joined: 18 Jun 2003
Posts: 316
Location: UK
|
Hi,
Transactional rollback is not guaranted based on just receiving an Exception. Transactional roll back is dependent on how you handle the exception in your flow. If your are processing the exception yourself using Failure terminals, TryCatch nodes, or have the Catch terminal of the MQInput node wired then no transactional rollback will occur. A transactional roll back will only occur if processing returns to the MQInput node, and either the catch terminal is not wired, or has already been executed.
_________________
Regards
Craig |
|
| Back to top |
|
|
| RAJESHRAMAKRISHNAN |
| Posted: Sun Feb 27, 2005 11:57 pm Post subject: |
|
|
Voyager
Joined: 01 May 2004
Posts: 96
|
| You can't have 'Automatic'. Try setting Commit. |
|
| 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
|
|
|
|
