Hub
Pricing About
NodeNode / ScopeEnd

DB Transaction End

DBTransaction
Drag & drop
Like

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:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits