When using DuckDB with Knime, getting error ---> Execute failed: A local transaction already exists.

Hello @gcraig ,
can you try to disable the transaction handling. To do so open the Advanced tab of the DB Connector node and disable Transaction support:

It seems that disabling the auto-commit behavior does not work for the DuckDB JDBC driver as described here.
Bye
Tobias

4 Likes