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

Antoine DESSAIGNE commented on CAMEL-7447:
------------------------------------------

It's not possible to stream the result with the SQL component because it uses 
Spring's {{JdbcTemplate}} which always closes the {{ResultSet}}.
In order to be able to stream the result, you need a finer control over the 
{{ResultSet.close()}} calls.

> Allow to stream the result of a database query
> ----------------------------------------------
>
>                 Key: CAMEL-7447
>                 URL: https://issues.apache.org/jira/browse/CAMEL-7447
>             Project: Camel
>          Issue Type: New Feature
>          Components: camel-jdbc
>            Reporter: Antoine DESSAIGNE
>             Fix For: 2.14.0
>
>
> Allow to stream the result of a database query
> Example:
> {code}
> from("direct:streamDB")
>     .setBody(constant("select * from customer"))
>     .to("jdbc:db?outputType=StreamList")
>     .split(body())
>         .to("direct:processSingleActor")
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to