Would a collection of integers work?
22. Nov. 2014 13:06 skrev "chaituu" <[email protected]>:
> 22 04:02:32,011 #0 - timer://timer1 TimerConsumer WARN
> warn MarkerIgnoringBase.java
> :136 Error processing exchange. Exchange[Message: UPDATE TEST SET
> FLAG='Y' WHERE ID IN(:?ids)]. Caused by: [java.sql.SQLSyntaxErrorException
> -
> ORA-01722: invalid number
> ]
> java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
>
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
>
> <route>
> <from uri="direct:sendUpdate"/>
> <setHeader headerName="ids">
> <simple>127,128</simple>
> </setHeader>
>
> <setBody>
> <constant>
> UPDATE TEST SET FLAG='Y' WHERE ID IN(:?ids)
> </constant>
> </setBody>
> <to uri="jdbc:dataSource?useHeadersAsParameters=true"/>
> <log message="update done on:${headers.ids}- "/>
> </route>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/how-to-execte-jdbc-IN-clause-statement-tp5759495.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
