Hello allansene,
we have just released KNIME 4.0.1 which now allows to disable transactions in the new DB framework (AP-12114).
To disable transactions simply open the dialog of the DB Connector node and go to the Advanced tab where you can disable transactions
For further details about the release see the changelog. To update simply open KNIME and go to File->Update KNIME…
Bye
Tobias