[jira] [Resolved] (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 resolved NIFI-5724.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 1.9.0

[~vishcious] I've added you to NiFi JIRA as a contributor. You can assign yourself to JIRAs now. Thanks again!

> 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
>             Fix For: 1.9.0
>
>
> 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)