[jira] [Created] (NIFI-7424) PutSQL - Flowfiles stuck in incoming queue due to java.sql.SQLException: Can't call commit when autocommit=true

["Ashish (Jira)" <ji...@apache.org>]

Ashish created NIFI-7424:
----------------------------

             Summary: PutSQL - Flowfiles stuck in incoming queue due to java.sql.SQLException: Can't call commit when autocommit=true
                 Key: NIFI-7424
                 URL: https://issues.apache.org/jira/browse/NIFI-7424
             Project: Apache NiFi
          Issue Type: Bug
    Affects Versions: 1.11.4, 1.10.0
            Reporter: Ashish
         Attachments: Data Flow.png, Error.png, PutSQL Properties.png, nifi-app.log

For standard processor PutSQL, with property "Database Session AutoCommit" set to TRUE, it does not allow the incoming flowfile to move to any of the relationships (SUCCESS, FAILURE, RETRY), since it throws the following error -

PutSQL[id=] Failed to process session due to Failed to commit database connection due to java.sql.SQLException: Can't call commit when autocommit=true: org.apache.nifi.processor.exception.ProcessException: Failed to commit database connection due to java.sql.SQLException: Can't call commit when autocommit=true

"Rollback On Failure" and "Support Fragmented Transactions" are set false with "Batch Size" value to 1. 

 

Flowfile Content

INSERT INTO user_nifi (id, name) VALUES (?, ?)

 

Flowfile Attributes (relevant)

sql.args.1.type
4
sql.args.1.value
25
sql.args.2.type
12
sql.args.2.value
Georgie



--
This message was sent by Atlassian Jira
(v8.3.4#803005)