Route Camel : Pass variables in a SQL query

[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: 

<route>
  <from uri="activemq:topic:XML.OUT.qmirror" /> 
  <setBody>
       <constant>UPDATE CAMEL SET B='${in.header.MessageId}' WHERE
C=2</constant> 
  </setBody>
  <to uri="jdbc:testdb" /> 
 </route>

When I tested this variable ${in.header.MessageId}, I retrieve its value,
unlike when I put this variable in the SQL query.

Otherwise, the SQL executes perfectly.

Thank you in advance for helping me complete this route

Best regards,

titexe
-- 
View this message in context: 
http://www.nabble.com/Route-Camel-%3A-Pass-variables-in-a-SQL-query-tp25635878p25635878.html
Sent from the Camel - Users mailing list archive at Nabble.com.