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

Reply via email to