I don't think camel-sql component support to get the value form message header. You may consider to use recipientList[1] to send the message to the endpoint which uri is generated dynamically.
[1]http://camel.apache.org/recipient-list.html -- Willem Jiang Red Hat, Inc. FuseSource is now part of Red Hat Web: http://www.fusesource.com | http://www.redhat.com Blog: http://willemjiang.blogspot.com (http://willemjiang.blogspot.com/) (English) http://jnn.iteye.com (http://jnn.javaeye.com/) (Chinese) Twitter: willemjiang Weibo: 姜宁willem On Wednesday, December 19, 2012 at 8:31 PM, sprabu wrote: > Hi, > I tried in 'n' number of way. At last i tried in the following way. Even now > i'm getting error. > > <to uri="sql:insert into TASK_TABLE > values(#header.msg_seq_no#,'TEST_CAMEL','112233','W-001','TEST','','','','')" > /> > > Can any one please help me to come out of it? > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/How-do-i-read-the-xml-element-values-from-the-xml-payload-and-have-to-pass-those-values-to-sql-query-tp5724291p5724362.html > Sent from the Camel - Users mailing list archive at Nabble.com > (http://Nabble.com).