Working with Database Transactions
The DB Transaction Start and DB Transaction End nodes allow you to model a database transaction, but there are limitations on how to make them work when the DML statements themselves are within a loop.
So here is a demonstration of providing MANUAL transaction handling using a recursive loop, along with DB SQL Executors.
@takbb Brian Bates 17 May 2024
Workflow
Manually writing a DB Transaction Outside a Loop
Used extensions & nodes
Created with KNIME Analytics Platform version 5.2.2
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.