Hi Claus, I did some more testing and it works only one scenario
from("timer://foo?fixedRate=true&period=6000") .setHeader("mobilenumbers", simple("12345")) .to("sql:select status from subscriber where mobilenumber in (:#in:mobilenumbers)?dataSource=#oracleDS") Even if i tried like below it again failed from("timer://foo?fixedRate=true&period=6000") .setHeader("mobilenumbers", simple("12345,56789")) .to("sql:select status from subscriber where mobilenumber in (:#in:mobilenumbers)?dataSource=#oracleDS") -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783279.html Sent from the Camel - Users mailing list archive at Nabble.com.