Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • Nodes
  • DB Transaction Start
NodeNode / ScopeStart

DB Transaction Start

This node starts a database transaction using the input database connection. A transaction allows you to group several database data manipulation operations into a single unit of work. This unit either completes entirely or not at all.

As long as the transaction is in process the incoming database connection cannot be used outside of the transaction.

Depending on the isolation level other connections might not see any changes in the database while the transaction is in process. The transaction uses the default isolation level of the connected database.

Node details

Input ports
  1. DB Connection Type: DB Session
    None-transactional DB Connection.
Output ports
  1. Transactional DB Connection Type: DB Session
    Transactional DB Connection.

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