[
https://issues.apache.org/jira/browse/NIFI-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16665625#comment-16665625
]
ASF GitHub Bot commented on NIFI-5724:
--------------------------------------
GitHub user viswaug opened a pull request:
https://github.com/apache/nifi/pull/3113
making the database connection autocommit value a configurable property
Currently, the PutSQL processor sets the database connection auto commit to
false before executing the SQL statement(s) and this is hardcoded in. This
commit makes the auto commit value being set to be configurable.
https://issues.apache.org/jira/projects/NIFI/issues/NIFI-5724?filter=allissues
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/Snagajob/nifi configurable_autocommit_putsql
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/nifi/pull/3113.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #3113
----
commit f63314c3db909d99acce1a071faa889a9cceca36
Author: Vish Uma <viswaug@...>
Date: 2018-10-26T19:32:46Z
making the database session autocommit value a configurable property
----
> 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
> 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)
