[jira] [Updated] (NIFI-11898) Handle auto-commit and commit based on driver capabilities in PutDatabaseRecord
[ https://issues.apache.org/jira/browse/NIFI-11898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Handermann updated NIFI-11898: Fix Version/s: 1.23.1 > Handle auto-commit and commit based on driver capabilities in > PutDatabaseRecord > --- > > Key: NIFI-11898 > URL: https://issues.apache.org/jira/browse/NIFI-11898 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Reporter: Matt Burgess >Assignee: Matt Burgess >Priority: Major > Fix For: 2.0.0, 1.24.0, 1.23.1 > > Time Spent: 40m > Remaining Estimate: 0h > > 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)
[jira] [Updated] (NIFI-11898) Handle auto-commit and commit based on driver capabilities in PutDatabaseRecord
[ https://issues.apache.org/jira/browse/NIFI-11898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Handermann updated NIFI-11898: Fix Version/s: (was: 1.23.1) > Handle auto-commit and commit based on driver capabilities in > PutDatabaseRecord > --- > > Key: NIFI-11898 > URL: https://issues.apache.org/jira/browse/NIFI-11898 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Reporter: Matt Burgess >Assignee: Matt Burgess >Priority: Major > Fix For: 2.0.0, 1.24.0 > > Time Spent: 40m > Remaining Estimate: 0h > > 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)
[jira] [Updated] (NIFI-11898) Handle auto-commit and commit based on driver capabilities in PutDatabaseRecord
[ https://issues.apache.org/jira/browse/NIFI-11898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Handermann updated NIFI-11898: Fix Version/s: 2.0.0 1.24.0 (was: 1.latest) (was: 2.latest) Resolution: Fixed Status: Resolved (was: Patch Available) > Handle auto-commit and commit based on driver capabilities in > PutDatabaseRecord > --- > > Key: NIFI-11898 > URL: https://issues.apache.org/jira/browse/NIFI-11898 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Reporter: Matt Burgess >Assignee: Matt Burgess >Priority: Major > Fix For: 2.0.0, 1.24.0 > > Time Spent: 40m > Remaining Estimate: 0h > > 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)
[jira] [Updated] (NIFI-11898) Handle auto-commit and commit based on driver capabilities in PutDatabaseRecord
[ https://issues.apache.org/jira/browse/NIFI-11898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Matt Burgess updated NIFI-11898: Status: Patch Available (was: In Progress) > Handle auto-commit and commit based on driver capabilities in > PutDatabaseRecord > --- > > Key: NIFI-11898 > URL: https://issues.apache.org/jira/browse/NIFI-11898 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Reporter: Matt Burgess >Assignee: Matt Burgess >Priority: Major > Fix For: 1.latest, 2.latest > > Time Spent: 10m > Remaining Estimate: 0h > > 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)