[
https://issues.apache.org/jira/browse/CAMEL-18157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17544448#comment-17544448
]
Grzegorz Anioł commented on CAMEL-18157:
----------------------------------------
It seems that processing huge tables may cause quickly OOM and high CPU rate in
that case :(
> camel-jdbc - The settings provided by the query parameter "parameters" are
> ignored
> ------------------------------------------------------------------------------------
>
> Key: CAMEL-18157
> URL: https://issues.apache.org/jira/browse/CAMEL-18157
> Project: Camel
> Issue Type: Bug
> Components: camel-jdbc
> Reporter: Andrea Evangelista
> Priority: Major
>
> The settings provided by the query parameter "parameters" are ignored when
> *useHeadersAsParameters* is true.
> Example:
> jdbc:xxxxx?{*}useHeadersAsParameters=true{*}&statement.fetchSize=100&outputType=StreamList&resetAutoCommit=false
> In this specific case *statement.fetchSize=100* will be ignored and all the
> rows will be fetched in memory for an sql query like this one:
> SELECT * from MY-BIG-TABLE
--
This message was sent by Atlassian Jira
(v8.20.7#820007)