Solved it! Thanks to Claus's suggestion from this post
http://camel.465427.n5.nabble.com/Stop-a-SQL-route-in-Apache-Camel-td5768252.html
I changed the structure to this!
from("timer:foo?period=5s")
.to("sqlComponent:{{sql.selectNewTopic}}")
.bean(new SqlDataConverter(), "transformContent")
.to("file:C:/Users/myname/Desktop/eclipse/workspace/CamelExample/resource/output");
Instead of using FROM for the sqlComponent, I used TO() instead. From is
now my timer, which sets how often it loops (period of 5 second on this
example). Thanks guys!
--
View this message in context:
http://camel.465427.n5.nabble.com/Camel-fetch-multiple-data-from-database-once-then-stops-tp5774117p5774121.html
Sent from the Camel - Users mailing list archive at Nabble.com.
