Hi Tom!
I don't think the component "camel-jdbc" supports any other type of named
parameter other than :?name. Looking at the code
(DefaultJdbcPrepareStatementStrategy) we see:
protected boolean hasNamedParameters(String query) {
NamedQueryParser parser = new NamedQueryParser(query);
Not camel SQL, camel JDBC.
The URL is jdbc: not sql:, and the named-placeholder is :? not :#.
There is a comment made by Claus Ibsen that it _DOES_ support it:
See: https://issues.apache.org/jira/browse/CAMEL-6157 at the end...
Claus Ibsen
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