nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shawn Weeks <>
Subject Re: PutSQL and AutoCommit Mode Still Commits
Date Wed, 03 Jun 2020 20:19:50 GMT
Per the JDBC Spec calling commit() on a connection in auto-commit should raise a SQLException
so what we’re doing is out of spec.

We should probably check c.getProperty(AUTO_COMMIT).asBoolean() and only call commit if we
weren’t in auto commit mode. I’ll file a jira


From: Shawn Weeks <>
Reply-To: "" <>
Date: Wednesday, June 3, 2020 at 2:27 PM
To: "" <>
Subject: PutSQL and AutoCommit Mode Still Commits

It appears that PutSQL calls a commit even when set to autoCommit true mode. This breaks things
if a driver raises an error on commit in autoCommit mode. For example redshift does this.


View raw message