Transaction

Operation Name

Transaction

Function Overview

Perform a transaction.
Flow enclosed by Transaction operation will start a new transaction. (The same behavior as REQUIRES_NEW)

For more details on transaction, refer to here.

Transaction Configuration

Icon	Name	Description
	Start Transaction	Start of Transaction.
	End Transaction	End of Transaction.

Properties

For details on use of variables, refer to “Variables”.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter the name to show on the script canvas.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this adapter. The description will be reflected in the specifications.

Right-click Menu

Icon	Item name	Description	Remarks
	Fold/Expand	Show/hide icons between [Start Transaction] and [End Transaction]. When folded, only [Start Transaction] will be displayed.

PSP Usage

PSP is not supported.

Specification Limits

You cannot set timeout.

When you place Raise Exception, end, break, or continue between Start Transaction icon and End Transaction icon, script compilation fails.

Major Exceptions

None.

Notes

Properties window cannot be opened.

Rollback or commit enclosed by Transaction operation will be judged based on the end status of the Transaction operation.
For example, even when an error occurs in a transaction, if the error is caught by Monitor Exception operation in the transaction, the transaction ends normally and so the processing will be committed.

Sample

The following script is an example. Using Transaction operation, when an error occurs in Launch External Application operation, it will roll back writing CSV file.

Create a script as follows.

Open the properties window of Write CSV File operation and check [Execute transaction processing] in [Transaction] tab.

Perform a invalid setting in order to make an error occurs in the Launch External Application operation.

Perform the mapping in Mapper as follows.

When running the script, you can confirm that the transaction is done correctly by referring to the CSV file contents and the execution history view log.