Questions on camel sql

[labo32_delaboe]

Hello together,

i have some questions on camel sql component.

I have a route which is invoked by a REST service.

My params are in ${body[0]}, ${body[1]} and ${body[2]} and I want to pass this parameters to a sql step

Is there a way to log the sql statement which is produced by the step above ?

Do I haven to provide the params in the right order in my REST service or is it posible

to change the order e.g use a placeholder like #1

Thanks

labo

Edited by: labo32 on Sep 23, 2011 5:18 AM

[davsclaus]

The parameters in the SQL should be in correct order, and does not support using named placeholders. So you have to use the # for each placeholder.

The body will be iterated, so it can contain a List which has the parameters.

The camel-sql component uses Spring JDBC under the hood, so that framework may log the SQL statement.

We may be able to improve camel-sql so it also logs the statement. But its using a PreparedStatement so the placeholders is bound.