Posted: Mon Sep 30, 2002 2:08 am Post subject: How to rollback the transactions.
Novice
Joined: 31 Jul 2002 Posts: 12 Location: Singapore
Hi all,
I need help how to rollback the transactions. I am using custom nodes for inserting into tables.
Here is the senario:
I am inserting into few tables. For logging errors also I am using one table called LOG table. while processing message flow i will log some information in to LOG table. whenever any exception occurs i want to rollback other tables but not LOG table. how to prevent this LOG table from rollback. Is there any other way to populate LOG table.
If I use propagate in custom node, when exception occurs whether propgated node also rollback ?
Most database nodes allow you to configure the trasaction mode.
eg. For the Compute node, the output datasource could be configured for trasaction mode "commit", so that the log entry would be immediately committed, regardless of the success of the flow.
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