camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mak <>
Subject Fetching from the JDBC component only once
Date Fri, 10 Dec 2010 06:16:27 GMT

Hi, I have the following route defined -


from("timer://foo?period=5000").setBody(constant("select top 500 *  from
MyTable where processed = 0"))
                .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:
Sent from the Camel - Users mailing list archive at

View raw message