Matt Burgess created NIFI-1691:
----------------------------------
Summary: 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
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)
