Grokbase Groups Camel users May 2016
FAQ
See the documentation at
http://camel.apache.org/sql-component.html

The section:
Using IN queries with dynamic values
On Mon, May 30, 2016 at 10:09 PM, imranrazakhan wrote:
Hi,

I am facing following error while using SQL IN clause

from("file://D:/Activity?fileName=BATCH_11.csv&noop=true")
.split( body().tokenize( System.getProperty("line.separator") )
).streaming()
.aggregate( constant(true), new ArrayListAggregationStrategy() )
.completionSize(1000)
.to("sql:select status from subscriber where mobilenumber in
(:#in:mobilenumbers)?dataSource=#oracleDS")
.....
.end();

it gives error

org.apache.camel.RuntimeExchangeException: Cannot find key [mobilenumbers]
in message body or headers to use when setting named parameter in query

I changed my route like below

from("file://D:/Activity?fileName=BATCH_11.csv&noop=true")
.split( body().tokenize( System.getProperty("line.separator") )
).streaming()
.aggregate( constant(true), new ArrayListAggregationStrategy() )
.completionSize(1000)
.setHeader("mobilenumbers", simple("${body}"))
.to("sql:select status from subscriber where mobilenumber in
(:#in:mobilenumbers)?dataSource=#oracleDS")

Now facing following error

org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state
[null]; error code [0]; Number of parameters mismatch. Expected: 1, was:
1000; nested exception is java.sql.SQLException: Number of parameters
mismatch. Expected: 1, was: 1000







--
View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264.html
Sent from the Camel - Users mailing list archive at Nabble.com.


--
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 18 | next ›
Discussion Overview
groupusers @
categoriescamel
postedMay 30, '16 at 8:09p
activeJun 1, '16 at 12:06p
posts18
users3
websitecamel.apache.org

People

Translate

site design / logo © 2017 Grokbase