Peter Wicks created NIFI-6862:
---------------------------------
Summary: Add Large Batch support to PutSQL
Key: NIFI-6862
URL: https://issues.apache.org/jira/browse/NIFI-6862
Project: Apache NiFi
Issue Type: Task
Components: Extensions
Reporter: Peter Wicks
Assignee: Peter Wicks
If PutSQL executes an Insert Statement that selects from table `A` and inserts
into table `B` the affected row count can exceed Int32.MaxValue. This causes
the execution to fail because the affected row count can't be captured as an
integer.
The fix is to execute using `executeLargeUpdate`, which returns the affected
row count as a long. Not all JDBC drivers support executing large batches, so
we need to support current `executeBatch` mode as well, with users opting in to
Large Batch mode.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
