camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sprabu <sathiyapr...@gmail.com>
Subject Re: How do i read the xml element values from the xml payload and have to pass those values to sql query.
Date Wed, 19 Dec 2012 10:08:52 GMT
Hi
I have in the follwoing way. But its showing me bad sql grammer exception.
Can you help me to come out of this.

<route>
<from uri="queue:com.TaskQueue1" />
<setHeader headerName="msg_no">
<xpath>//MESSAGE_NUMBER</xpath>
</setHeader>
<to uri="sql:insert into TASK_TABLE
values(${header.msg_seq_no},'TEST_CAMEL','112233','W-001','TEST','','','','')"
/>
.......	
How do i get the value and set it in sql?

Thanks in advance!
				



--
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-tp5724291p5724353.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message