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.
