Hi, This is the route code.
from("sql:select rowid vrow_id from myTable where nstatus = 0" + MyBean.class.getName() + "&onConsume=update myTable set nstatus = 1 where VROW_ID = :#${body.vrow_id}") .routeId("mySimpleRoute").threads(5).to("direct:generateLine").end(); In the following from("direct:generateLine"), I apply bean-binding and send myBean.toString() to a file... Thanks again -- View this message in context: http://camel.465427.n5.nabble.com/DefaultSqlPrepareStatementStrategy-lookupParameter-when-onConsume-used-in-SQL-component-tp5780437p5780624.html Sent from the Camel - Users mailing list archive at Nabble.com.