Hub
NodeNode / ScopeEnd

DB Transaction End

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.

Node details

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).

Related workflows & nodes

  1. Returning data for modified rows in PostgreSQL
    PostgreSQL database db
    This workflow demonstrates how the DB Query Reader node can be used to execute a DML statement that returns the changed…
    tobias.koetter > Public > DB > PostgreSQL > PostgresInsertWithReturn
  2. 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
  3. 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…
    lcs > Public > 01_Data_Access > 02_Databases > 13_DBTransactionExample