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

DB Transaction Start

DB Transaction
Drag & drop
Like
Copy short link

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. Type: DB Session
    DB Connection
    None-transactional DB Connection.
Output ports
  1. Type: DB Session
    Transactional DB Connection
    Transactional DB Connection.

Extension

The DB Transaction Start node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    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. Go to item
    Working with user-defined database variables
    Db Database Variable
    This workflow demonstrates how you can create user-defined database variables in KNIME us…
    tobias.koetter > Public > DB > DBVariables
  3. Go to item
    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
  4. Go to item
    データベースのトランザクション処理
    Db Database Transaction
    DB Transaction StartノードとDB Transaction Endノードでは、データベーストランザクション、つまり、完全に処理されるか、全く処理されないかの作業…
    infocom > Public > 01_データアクセス > 02_データベース > 13_データベースのトランザクション処理
  5. Go to item
    Called
    tttpham > Public > Pb Transaction End > Called

No known nodes available

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
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits