Grokbase Groups Camel users May 2016

I wonder if its the Oracle JDBC driver issue, that it does not return
correct value for number of parameters in the prepared statement.

There is an option parametersCount you can use to set a fixed value if
the JDBC driver cannot return correct data. See its documentation

However that value is fixed, and if you use a dynamic IN list then you
would need to use <toD> to make the uri dynamic. (less good but
possible). But at least maybe try to set that value = 1000 as you use
in your example, and see if that at least work.
On Tue, May 31, 2016 at 6:09 PM, yogu13 wrote:
i see unit tests written for supporting in clause not sure how r they


On Tuesday 31 May 2016, imranrazakhan [via Camel] <> wrote:
Hi Yogesh,

it look like there is issue in Using IN queries with dynamic values, as
its working for 1 value but not for multiple values, if here is issue in
datasource parameter then it should not work for 1 value too.

As mentioned earlier is expecting 1 value, below error clearly indicating

PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state
[null]; error code [0];
Number of parameters mismatch. Expected: 1, was: 5; nested exception is
java.sql.SQLException: Number of parameters mismatch. Expected: 1, was: 5


If you reply to this email, your message will be added to the discussion
To unsubscribe from camel-sql - SQL IN Query issue (2.17.1), click here

View this message in context:
Sent from the Camel - Users mailing list archive at

Claus Ibsen
----------------- @davsclaus
Camel in Action 2:

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 17 of 18 | next ›
Discussion Overview
groupusers @
postedMay 30, '16 at 8:09p
activeJun 1, '16 at 12:06p



site design / logo © 2018 Grokbase