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
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!