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)

Reply via email to