Hi 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 http://camel.apache.org/sql-component.html 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 <yog...@gmail.com> wrote: > i see unit tests written for supporting in clause not sure how r they > passing > > regards, > -Yogesh > > On Tuesday 31 May 2016, imranrazakhan [via Camel] < > ml-node+s465427n5783319...@n5.nabble.com> 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 >> >> org.springframework.jdbc.UncategorizedSQLException: >> 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 >> >> >> Regards >> >> ------------------------------ >> If you reply to this email, your message will be added to the discussion >> below: >> >> http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783319.html >> To unsubscribe from camel-sql - SQL IN Query issue (2.17.1), click here >> <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5783264&code=eW9ndTEzQGdtYWlsLmNvbXw1NzgzMjY0fC04ODQzODQxMjM=> >> . >> NAML >> <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >> > > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783321.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen ----------------- http://davsclaus.com @davsclaus Camel in Action 2: https://www.manning.com/ibsen2
