camel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Willem Jiang <willem.ji...@gmail.com>
Subject Re: Stream the result of a database query
Date Tue, 20 May 2014 02:44:26 GMT
It sounds good. Please feel free to do it.

--  
Willem Jiang

Red Hat, Inc.
Web: http://www.redhat.com
Blog: http://willemjiang.blogspot.com (English)
http://jnn.iteye.com (Chinese)
Twitter: willemjiang  
Weibo: 姜宁willem



On May 20, 2014 at 1:00:21 AM, Antoine DESSAIGNE (antoine.dessaigne@gmail.com) wrote:
> Hi everyone,
>  
> I've looked into the source code and it doesn't seem like its possible to
> stream the result of an SQL query in camel using either the SqlComponent or
> the JdbcComponent. This would be really useful when reading a large DataSet.
>  
> If you confirm that it's not the case right now, I would gladly fill a JIRA
> issue and submit a pull request. I think I'm going to use another option in
> SqlOutputType named StreamList and return an Iterator that wraps the
> ResultSet in this case
>  
> That way it would look like
> from("direct:streamDB")
> .to("sql:select * from actors?outputType=StreamList")
> .split(body())
> .to("direct:processSingleActor")
>  
> What do you think ?
>  
> Antoine.
>  


Mime
View raw message