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:
<route> <from uri="timer://foo?fixedRate=true&period=60000"/> <to uri="bean:lastRowValue?method=getLastValue"/> <to uri="sql:select * from messagesRepo1 Order By id?dataSourceRef=dataSource1"/> <to uri="bean:lastRowValue?method=setLastValue"/> </route> Thanks -- View this message in context: http://camel.465427.n5.nabble.com/Get-updated-entries-from-a-DataBase-tp3400895p4552420.html Sent from the Camel - Users mailing list archive at Nabble.com.