Matt Burgess created NIFI-12010:
-----------------------------------
Summary: Handle auto-commit and commit based on driver
capabilities in SQL components
Key: NIFI-12010
URL: https://issues.apache.org/jira/browse/NIFI-12010
Project: Apache NiFi
Issue Type: Improvement
Components: Extensions
Reporter: Matt Burgess
Assignee: Matt Burgess
Fix For: 2.0.0, 1.24.0
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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
