camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaituu <yarlagadd...@gmail.com>
Subject how to execte jdbc IN clause statement
Date Sat, 22 Nov 2014 12:05:52 GMT
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
View raw message