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.