You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Peter Wicks (Jira)" <ji...@apache.org> on 2019/11/12 14:53:00 UTC

[jira] [Created] (NIFI-6862) Add Large Batch support to PutSQL

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)