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

Posted to issues@camel.apache.org by "Grzegorz Anioł (Jira)" <ji...@apache.org> on 2022/05/31 15:05:00 UTC

[jira] [Commented] (CAMEL-18157) camel-jdbc - The settings provided by the query parameter "parameters" are ignored

    [ 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)