Hi

The Splitter EIP can run in streaming mode.

Then use a custom expression that returns an Iterator, the the
splitter will use the iterator to read in a one row at a time.
eg return an iterator that walks the ResultSet.



On Thu, Mar 8, 2012 at 3:19 PM, Walter De Wit <walte...@gmail.com> wrote:
> Hello,
>
> I want to use the output of a SQL query as input for my processing where
> each record of the resultset becomes an exchange.
> It is like the file: producer in streaming mode.
> The resultset of the query is too big to load in memory in one List<?>
> instance.
> With frameworks like iBatis it is possible to define RowHandlers so you
> only have one record at a time in memory. The standard JDBC ResultSet is
> also implemented this way.
> Does such a Camel component exist already ? The SQL component does not seem
> to have this option.
> If not, any useful tips to implement it myself are welcome.
>
> thanks already for the good work.
> Walter



-- 
Claus Ibsen
-----------------
FuseSource
Email: cib...@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/

Reply via email to