camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Karlsen <davidkarl...@gmail.com>
Subject Re: how to execte jdbc IN clause statement
Date Sat, 22 Nov 2014 21:34:40 GMT
Would a collection of integers work?
22. Nov. 2014 13:06 skrev "chaituu" <yarlagadda54@gmail.com>:

> 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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message