Re: Route Camel : Pass variables in a SQL query

2014-10-19 Thread sayed_india
Thanks for the response. My question am not able to get the id param value in the SQL query throws error as invalid SQL query as the :id is not replaced with the value. Best regards, Sayed -- View this message in context: http://camel.465427.n5.nabble.com/Route-Camel-Pass-variables-in-a-SQL

Re: Route Camel : Pass variables in a SQL query

2014-09-09 Thread Charles Moulliard
he > required query. > > Please correct the code: > > > ${header.operationName} == 'getCompany' > > $simple{body} > > > > > > Thanks, > > > > -- > View this messa

Re: Route Camel : Pass variables in a SQL query

2014-09-08 Thread sayed_india
message in context: http://camel.465427.n5.nabble.com/Route-Camel-Pass-variables-in-a-SQL-query-tp477181p5756205.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Route Camel : Pass variables in a SQL query

2009-09-30 Thread titexe
Problem fixed : expression simple Thank you titexe wrote: > > Hello, > > I'm trying to develop a route camel who can: > > Retrieve a value from the header of a message > and put this value in an SQL query. > > Below my configuration: > > > > >UPDATE CAMEL SET B='${in.h

Re: Route Camel : Pass variables in a SQL query

2009-09-27 Thread Claus Ibsen
On Sun, Sep 27, 2009 at 8:24 PM, Roman Kalukiewicz wrote: > You set the body to constant value, so you have constant value. Use EL > expression instead of constant one if you want it to be evaluated. > > In simple words put where you have ;) > The requires that you have camel-juel.jar on the c

Re: Route Camel : Pass variables in a SQL query

2009-09-27 Thread Roman Kalukiewicz
You set the body to constant value, so you have constant value. Use EL expression instead of constant one if you want it to be evaluated. In simple words put where you have ;) Roman 2009/9/27 titexe : > > Hello, > > I'm trying to develop a route camel who can: > > Retrieve a value from the hea

Route Camel : Pass variables in a SQL query

2009-09-27 Thread titexe
Hello, I'm trying to develop a route camel who can: Retrieve a value from the header of a message and put this value in an SQL query. Below my configuration: UPDATE CAMEL SET B='${in.header.MessageId}' WHERE C=2 When I tested this variable ${in.header.MessageId},