[
https://issues.apache.org/jira/browse/NIFI-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16681051#comment-16681051
]
ASF subversion and git services commented on NIFI-5724:
-------------------------------------------------------
Commit 63f55d05b4f3f83b9e9f2206f4129ae7a4ade569 in nifi's branch
refs/heads/master from Vish Uma
[ https://git-wip-us.apache.org/repos/asf?p=nifi.git;h=63f55d0 ]
NIFI-5724 make database connection autocommit configurable
making the database session autocommit value a configurable property
adding custom validation to PutSQL processor so as to disallow 'supports
transaction' and 'rollback on failure' to be true when the autocommit value has
been set to true
fixing some style issues to conform to standards
This closes #3113.
Signed-off-by: Koji Kawamura <[email protected]>
> 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)
