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)
