[jira] [Assigned] (NIFI-5724) Make the autocommit value in the PutSQL processor configurable

["Koji Kawamura (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Koji Kawamura reassigned NIFI-5724:
-----------------------------------

    Assignee: vish uma

> 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
>            Assignee: vish uma
>            Priority: Minor
>
> 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)