Try newer Camel version On Tue, Apr 18, 2017 at 3:47 PM, akpcnu <srini...@live.com> wrote: > I am using CAMEL 2.17.3 and having two IN clauses in SQL query causes below > exception: > > org.springframework.jdbc.UncategorizedSQLException: > PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state > [null]; error code [0]; Number of parameters mismatch. Expected: 4, was: 8; > nested exception is java.sql.SQLException: Number of parameters mismatch. > Expected: 4, was: 8 > > If I have one IN clause query is working fine. Is this known bug or > behavior? if yes, any alternative? > > ex: > > SELECT column1, column2... > FROM < >> > WHERE column1 IN (:#in:<<dynamically build>>) > column2 IN (:#in:<<dynamically build>>) > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Camel-SQL-more-than-one-IN-clauses-in-SQL-throws-Exception-tp5797818.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
