You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@camel.apache.org by Cecilio Alvarez <ce...@hotmail.com> on 2013/11/14 11:23:38 UTC

Sql component headers and body in query.

Hi,

I have the following sql endpoint:

<to uri="sql:insert into table(id,payload) values(:#Name,xmlparse(document
cast(# as clob) preserve whitespace))?dataSource=derby/>

It throws java.sql.SQLException: Number of parameters mismatch. Expected 2,
was: 1

If I send just headers It works, but I don't want to set the body in a
header....

If I send a List containing the parameters as the documentation says it
works.


Thanks!



--
View this message in context: http://camel.465427.n5.nabble.com/Sql-component-headers-and-body-in-query-tp5743260.html
Sent from the Camel - Users mailing list archive at Nabble.com.