What's with the dynamic router [1]? Will this work for you?
from("direct:start")
// checks whether direct:slip should be called again
.dynamicRouter(method(DynamicRouterTest.class, "slip"));
from("direct:slip")
.to("sql:select top 10 * from MyTable")
.to(“bean:process10Rows”)
[1] http://camel.apache.org/dynamic-router.html
Best,
Christian
On Wed, Nov 14, 2012 at 4:12 PM, Zhemzhitsky Sergey <
[email protected]> wrote:
> Hello camel gurus,
>
> Could you suggest a best way to process a large jdbc result set that
> contains, let’s say, more than 10000 rows.
>
> What I need is to fetch all the new rows from a given table when the timer
> event fires.
> Currently jdbc components (jdbc, sql, jpa, mybatis, etc.) do not support
> batching, so what I’d like to implement is something like this
>
> from(“timer:triggerName”)
> .repeat(new HasMoreRowsPredicate())
> .to(“sql:select top 10 * from MyTable”)
> .to(“bean:process10Rows”)
>
> Loop EIP seems very similar to what I need, but it must be initialized
> with a predefined number of repetitions.
>
> Best Regards,
> Sergey
>
>
> _______________________________________________________
> CONFIDENTIALITY NOTICE: This email and any files attached to it may be
> confidential. If you are not the intended recipient you are notified that
> using, copying, distributing or taking any action in reliance on the
> contents of this information is strictly prohibited. If you have received
> this email in error please notify the sender and delete this email.
>
>
--
