Skip to main content

Commit Transaction

Commits a SQLite database transaction.

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​

  • Transaction Id - The identifier of the transaction to commit.

How It Works​

The Commit node is used to commit a SQLite database transaction. When executed, the node:

  1. Validates the provided Transaction Id input
  2. Acquires a mutex lock to ensure thread safety
  3. Looks up the transaction in the SQLite transaction store
  4. Commits the transaction if found
  5. Releases the mutex lock

Requirements​

  • A valid transaction identifier from a previously started SQLite transaction
  • An active SQLite connection

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Transaction Id
  • Transaction with the specified Id not found
  • Database connection issues

Usage Notes​

  • The Transaction Id should match the one used when starting the transaction
  • Always ensure transactions are properly committed or rolled back to maintain database integrity
  • This node should be used in conjunction with Start Transaction and other SQLite nodes