Hub
NodeNode / ScopeEnd

DB Transaction End

DB Transaction
Drag & drop
Like
Copy short link

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. Type: DB Session
    Transactional DB Connection
    Transactional DB Connection.
  2. Type: DB Session
    Original transactional DB Connection
    Output DB Connection of the DB Transaction Start node.
Output ports
  1. Type: DB Session
    DB Connection
    None-transactional DB Connection.
  2. Type: Flow Variable
    Successful transaction
    Flow variable connection only active for successful (committed) transactions.
  3. Type: Flow Variable
    Failed transaction
    Flow variable connection only active for failed (rollback) transactions including failure (if any).

Extension

The DB Transaction End node is part of this extension:

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 stat…
    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 trans…
    knime > Examples > 01_Data_Access > 02_Databases > 13_DBTransactionExample
  3. データベースのトランザクション処理
    Db Database Transaction
    DB Transaction StartノードとDB Transaction Endノードでは、データベーストランザクション、つまり、完全に処理されるか、全く処理されないかの作業…
    infocom > Public > 01_データアクセス > 02_データベース > 13_データベースのトランザクション処理
  4. Called
    tttpham > Public > Pb Transaction End > Called