Get updated entries from a DataBase

2011-02-25 Thread frblondin
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 lik

Re: Get updated entries from a DataBase

2011-07-05 Thread frblondin
Thanks, this works! One last question: how do i split a list in my route? My problem is that the sql component returns a list and I'like to manage each item within the list. In my route below the whole query result (list) is sent to my bean instead of each line individually:

Re: Get updated entries from a DataBase

2011-07-05 Thread frblondin
Nevermind, I used this: body -- View this message in context: http://camel.465427.n5.