Fwd: jdbc: with non-named parameter?

[Tom Oehser <To...@Toms.NET>]

Hey - trying to share some SQL between a Camel jdbc: app and a Spring
jdbc-template app...

the SQL is like

     "blah blah ? blah blah"

- can't figure out how to get camel jdbc: to support the ? (regular
non-named) parameter.

I see the named parameter support - I could change the SQL -

but -

it looks like camel uses :?name and spring jdbc templates use :name
(different named parameter syntax).

So... is there a way to support the regular ? parameter in camel jdbc: ???

Re: Fwd: jdbc: with non-named parameter?

[Miguel Ruiz Velasco Sobrino <mi...@fcm.com.mx>]

Hi Tom,
Camel JDBC component (camel-sql) only supports named parameters for one reason:You specify both the place of the parameter AND the source of the value (name of header or key of body).The placeholder camel-sql is :#
If you really want to support plain old ? JDBC placeholders, you will need to write a custom Processor. My advice is to change your SQL query to use the camel mechanism (:#)


Miguel Ruiz Velasco SobrinoFCM Computación Mexicana


-------- Mensaje original --------De: Tom Oehser <To...@Toms.NET> Fecha: 30/3/18  13:58  (GMT-06:00) A: users@camel.apache.org Asunto: Fwd: jdbc: with non-named parameter? 


Hey - trying to share some SQL between a Camel jdbc: app and a Spring
jdbc-template app...

the SQL is like

     "blah blah ? blah blah"

- can't figure out how to get camel jdbc: to support the ? (regular
non-named) parameter.

I see the named parameter support - I could change the SQL -

but -

it looks like camel uses :?name and spring jdbc templates use :name
(different named parameter syntax).

So... is there a way to support the regular ? parameter in camel jdbc: ???