camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mak <makk...@gmail.com>
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"))
                .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.

Mime
View raw message