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 ([email protected]) 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. >
