NodeDB Transaction End

ScopeEnd

This node ends the transaction of the input database connection.

The node ends the transaction with a commit that makes all changes visible to other users if its body executed successfully. Otherwise the node ends the transaction with a rollback returning the database to the state at the beginning of the transaction.

Input ports
  1. Transactional DB Connection Type: DB Session
    Transactional DB Connection.
  2. Original transactional DB Connection Type: DB Session
    Output DB Connection of the DB Transaction Start node.
Output ports
  1. DB Connection Type: DB Session
    None-transactional DB Connection.
  2. Successful transaction Type: Flow Variable
    Flow variable connection only active for successful (committed) transactions.
  3. Failed transaction Type: Flow Variable
    Flow variable connection only active for failed (rollback) transactions including failure (if any).
  1. Working with Database Transactions
    db database transaction
    The DB Transaction Start and DB Transaction End nodes allow you to model a database transaction, i.e. a unit of work th…
    knime > Examples > 01_Data_Access > 02_Databases > 13_DBTransactionExample