Re: Get updated entries from a DataBase

[frblondin <th...@gmail.com>]

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&amp;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.

Re: Get updated entries from a DataBase

[frblondin <th...@gmail.com>]

Nevermind, I used this:


		<route>
			<from uri="timer://foo?fixedRate=true&amp;period=60000"/>
			<to uri="bean:lastRowValue?method=getLastValue"/>
			<to uri="sql:select * from messagesRepo1 Order By
id?dataSourceRef=dataSource1"/>
			<split>
			<simple>body</simple> 
			<to uri="bean:lastRowValue?method=setLastValue"/>
			</split>
		</route>


--
View this message in context: http://camel.465427.n5.nabble.com/Get-updated-entries-from-a-DataBase-tp3400895p4552432.html
Sent from the Camel - Users mailing list archive at Nabble.com.