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

I am getting these errors —>

Execute failed: A local transaction already exists.

OR

Error during fetching data from the database: java.sql.SQLException: A local transaction already exists.

OR

TransactionContext Error: cannot rollback - no transaction is active

when trying to execute a DuckDB query in the DB nodes downstream of the DB Connector. Using Knime on macOS. What step am I missing?

Helpful links I’ve already explored:

DuckDB is an in-process SQL OLAP database management system

A DuckDB team member showing screenshots connecting DuckDB to Knime via JDBC

DuckDB JDBC Documentation

DuckDB JDBC macOS Driver - duckdb_jdbc-osx-amd64.jar

DuckDB SQL syntax

DuckDB Paquet Query syntax

Knime Database Extension Guide

Registering DuckDB JDBC

DB Connector Config

Query Error

Error during fetching data from the database: java.sql.SQLException: A local transaction already exists.

Workflow