[jira] [Commented] (NIFI-1691) Add Fetch Size property to QueryDatabaseTable processor

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-1691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15224574#comment-15224574 ] 

ASF subversion and git services commented on NIFI-1691:
-------------------------------------------------------

Commit 980317ba04c55d0b145747e4db9310d9911956cb in nifi's branch refs/heads/support/nifi-0.6.x from [~mattyb149]
[ https://git-wip-us.apache.org/repos/asf?p=nifi.git;h=980317b ]

NIFI-1691: Add Fetch Size property to QueryDatabaseTable

This closes #307

Signed-off-by: Bryan Bende <bb...@apache.org>


> Add Fetch Size property to QueryDatabaseTable processor
> -------------------------------------------------------
>
>                 Key: NIFI-1691
>                 URL: https://issues.apache.org/jira/browse/NIFI-1691
>             Project: Apache NiFi
>          Issue Type: Improvement
>    Affects Versions: 0.6.0
>            Reporter: Matt Burgess
>            Assignee: Matt Burgess
>             Fix For: 0.7.0, 0.6.1
>
>
> The QueryDatabaseTable processor does not have a way for the user to set the fetch size for the JDBC query. Some drivers (like Oracle) default to a fetch size of 1, which means result rows needs to be fetched one at a time from the database. This can be very slow, an improvement would be to allow the user to set the fetch size for the query.
> NOTE: Some drivers do not support this, either by throwing an exception or ignoring it (the JDBC spec marks it as a "hint to the database", the doc for the property should make this clear and no exception should be propagated through the processor if the attempt to set fetch size is unsuccessful.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)