[NIFI-11898] Handle auto-commit and commit based on driver capabilities in PutDatabaseRecord

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0-M1, 1.24.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 02/Aug/23 00:24
• Updated: 29/Aug/23 16:48
• Resolved: 03/Aug/23 21:50

Description

Some JDBC drivers throw an exception when calling setAutoCommit(false), even if the auto-commit setting for the driver is already false. Although unfortunate, I'm not sure it is a violation of the JDBC API. PutDatabaseRecord should catch SQLFeatureNotSupportedException and perhaps log a debug message but otherwise proceed.

Same goes for connection.commit() and connection.rollback(), these should not be explicitly called if auto-commit is true for the connection.

Issue Links

• is cloned by: NIFI-12010 Handle auto-commit and commit based on driver capabilities in SQL components
• links to: GitHub Pull Request #7560
• links to: GitHub Pull Request #7560
• links to: GitHub Pull Request #7561