According to the camel-sql documentation, you must set the message body with a java.util.Iterator containing the parameters used in your query (in the correct order). * att. Henrique Viecili*
On Wed, Dec 19, 2012 at 11:05 AM, Willem jiang <willem.ji...@gmail.com>wrote: > 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). > > > >