[NIFI-7503] PutSQL Shouldn't Commit When in AutoCommit Mode

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Shawn Weeks
• Created: 03/Jun/20 20:21
• Updated: 29/Sep/20 09:13
• Resolved: 29/Sep/20 09:13

Description

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()

Issue Links

• links to: GitHub Pull Request #4558