The output from the from is a Map, so you should refer to the value by referring to the column name.
where VROW_ID = :#vrow_id On Thu, Apr 7, 2016 at 6:44 AM, onders <ondersezgin+camelu...@gmail.com> wrote: > 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. -- Claus Ibsen ----------------- http://davsclaus.com @davsclaus Camel in Action 2: https://www.manning.com/ibsen2