[
https://issues.apache.org/jira/browse/NIFI-7503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17203484#comment-17203484
]
Matt Burgess commented on NIFI-7503:
------------------------------------
Calling commit() and/or rollback() on the Connection, per the JDBC spec (see
java.sql.Connection docs), should only be performed if auto-commit is disabled.
> PutSQL Shouldn't Commit When in AutoCommit Mode
> -----------------------------------------------
>
> Key: NIFI-7503
> URL: https://issues.apache.org/jira/browse/NIFI-7503
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: Shawn Weeks
> Assignee: Matt Burgess
> Priority: Minor
>
> PutSQL Commits even when autoCommit is true. Some drivers like RedShift raise
> an exception and the JDBC Spec allows for an exception here. Recommend we
> check to see if autoCommit is true before calling commit.
> https://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#commit()
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
