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 -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783319.html Sent from the Camel - Users mailing list archive at Nabble.com.