Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • knime
  • Spaces
  • Examples
  • 01_Data_Access
  • 02_Databases
  • 13_DBTransactionExample
WorkflowWorkflow

Working with Database Transactions

Db Database Transaction

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
The DB Transaction Start and DB Transaction End nodes allow you to model a database transaction, i.e. a unit of work that is either completely processed or not at all. So, if all nodes between the DB Transaction Start and DB Transaction End nodes execute successfully, all changes will be persisted in the database. Likewise, if any of the nodes between the two transaction nodes fails, none of the changes will be persisted in the database. Note that most databases do an implicit commit when executing a DDL statement such as create or drop table even within a transaction.

External resources

  • Transaction section in the KNIME Database Extension Guide
  • Database Transaction Description

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.0
  • Go to item
    KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Database Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

By using or downloading the workflow, you agree to our terms and conditions.

Discussion
Discussions are currently not available, please try again later.

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