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

2018-04-02 Thread Ricardo Zanini
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);

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

2018-03-31 Thread Tom Oehser
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

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

2018-03-31 Thread Miguel Ruiz Velasco Sobrino
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