Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • Nodes
  • DB Transaction End
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

No known nodes available

Extension

This node is part of the extension

KNIME DatabaseTrusted extension
Version 4.3.0
Short link

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits