Hi You can code the SQL logic in a java bean, and then use the @Produce or ProducerTemplate to easily send the message to a Camel route for further processing.
Then you can use another Camel route with a timer to schedule invoking your bean at X given interval. On Fri, Feb 25, 2011 at 11:02 PM, frblondin <thomas.cau...@gmail.com> wrote: > > Hi, > > I'm new to Camel. My need is to collect new information from an existing > DataBase. My cursor is quite easy to manage (based on a timestamp) so I need > to regularly check for new entries every minute by doing this query: "Select > * From Table Where DTEVENT > LastManagedEntryDT". > > Ideally I'd like to use Spring configuration and the LastManagedEntryDT > value should be stored in a persistent file so that if I restart Camel I > won't grab duplicates events. > > Thanks! > -- > View this message in context: > http://camel.465427.n5.nabble.com/Get-updated-entries-from-a-DataBase-tp3400895p3400895.html > Sent from the Camel - Users mailing list archive at Nabble.com. > -- Claus Ibsen ----------------- FuseSource Email: cib...@fusesource.com Web: http://fusesource.com Twitter: davsclaus Blog: http://davsclaus.blogspot.com/ Author of Camel in Action: http://www.manning.com/ibsen/
