Skip to main content

Start Transaction

Starts a new transaction in an Oracle database.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Connection Id - The ID of the database connection to use for the transaction.

Output​

  • Transaction Id - The ID of the newly created transaction.

How It Works​

The Start Transaction node begins a new database transaction by:

  1. Validating the provided Connection Id
  2. Looking up the connection in the shared connections dictionary
  3. Generating a unique GUID for the transaction
  4. Beginning a transaction on the database connection using BeginTransaction()
  5. Storing the transaction in the shared transactions dictionary
  6. Returning the transaction ID as output

Requirements​

  • An active database connection established with the Connect node
  • Valid connection ID that corresponds to an active connection

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Connection Id
  • Connection ID not found in the connections dictionary

Usage Notes​

  • The Connection Id must be valid and correspond to an active connection
  • The returned Transaction Id should be used with other database nodes that support transactions
  • Transactions should be committed using the Commit Transaction node or rolled back using a rollback mechanism
  • Transactions help ensure data consistency and can be rolled back in case of errors
  • Each transaction is isolated from other transactions until committed