vish uma created NIFI-5724: ------------------------------ Summary: Make the autocommit value in the PutSQL processor configurable Key: NIFI-5724 URL: https://issues.apache.org/jira/browse/NIFI-5724 Project: Apache NiFi Issue Type: Improvement Components: Extensions Reporter: vish uma
The PutSQL processor currently always sets the autocommit value on the database session to false before the SQL statement is run and resets it back to the original value after. i am not sure if the autocommit value is hardcoded to false for a reason, if it is, please let me know. This is causing an issue with the snowflake DB where abruptly disconnected sessions do not release the locks they have taken. i would like to make this autocommit value configurable. I can submit a patch for this if there is no objections. -- This message was sent by Atlassian JIRA (v7.6.3#76005)