Hi, I have the following route defined -
from("timer://foo?period=5000").setBody(constant("select top 500 * from
MyTable where processed = 0"))
.to("jdbc:dataSource").split(body()).parallelProcessing()
.process(new MyProcessor()).unmarshal(jaxb)....
In this configuration, I am polling the database every 5 seconds and
fetching the first 500 records with each poll.
What I really want to do is work on ALL the records in this table, 500 at a
time ONLY ONCE. So I do not want the timer component in there.
Can someone guide me with such a route definition?
--
View this message in context:
http://camel.465427.n5.nabble.com/Fetching-from-the-JDBC-component-only-once-tp3299863p3299863.html
Sent from the Camel - Users mailing list archive at Nabble.com.
