Difference between revisions of "Transaction Control Nodes"
(→Transaction Control Nodes) |
|||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | == Transaction Control Nodes == | ||
+ | |||
'''Transaction Control Nodes''' provide a mechanism to roll back database transactions following an error or unexpected conditions, or to commit outstanding transactions following successful completion of other criteria. | '''Transaction Control Nodes''' provide a mechanism to roll back database transactions following an error or unexpected conditions, or to commit outstanding transactions following successful completion of other criteria. | ||
− | + | Typically these will be combined with an [[Error Handler]], as with the example Task below: | |
+ | |||
+ | [[file:transaction_nodes.png]] | ||
+ | |||
+ | This Task schematic describes how to handle the following situation: | ||
+ | |||
+ | # "Update Table 1" succeeds | ||
+ | # "Update Table 2" succeeds | ||
+ | # "Update Table 3" fails | ||
+ | |||
+ | In this instance we want to rollback the updates performed by "Update Table 1" and "Update Table 2", which is performed by the Rollback Node after catching the error generated by "Update Table 3". Similarly, if "Update Table 2" fails, updates performed by "Update Table 1" will be rolled back. Only if all three SQL statements succeed will the changes be committed. | ||
+ | |||
+ | '''Note:''' Commit and Rollback nodes will only take effect if "Commit transactions later in Task" is selected under "Transaction Options" on the SQL Editor. | ||
+ | |||
+ | ---- | ||
− | + | == See Also == | |
− | + | {{DataAccess}} |
Latest revision as of 09:55, 20 August 2015
Transaction Control Nodes
Transaction Control Nodes provide a mechanism to roll back database transactions following an error or unexpected conditions, or to commit outstanding transactions following successful completion of other criteria.
Typically these will be combined with an Error Handler, as with the example Task below:
This Task schematic describes how to handle the following situation:
- "Update Table 1" succeeds
- "Update Table 2" succeeds
- "Update Table 3" fails
In this instance we want to rollback the updates performed by "Update Table 1" and "Update Table 2", which is performed by the Rollback Node after catching the error generated by "Update Table 3". Similarly, if "Update Table 2" fails, updates performed by "Update Table 1" will be rolled back. Only if all three SQL statements succeed will the changes be committed.
Note: Commit and Rollback nodes will only take effect if "Commit transactions later in Task" is selected under "Transaction Options" on the SQL Editor.
See Also
Task Elements : Data Accesss Task Elements : Transaction Control Nodes
SQL Statement Nodes | Object Monitor Nodes | XML Query Nodes | Mail Scanner Nodes |
Web Services Nodes | LDAP Query Nodes | JSON Node | Flat File Parser | Data Table Nodes | Variable Nodes |
Transaction Control Nodes | Context XML Nodes |