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.
