ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From begineer <redni...@gmail.com>
Subject Re: Getting exception in SQL Query JOINS
Date Thu, 04 Aug 2016 07:33:34 GMT
Does it work for single parameter only. If I pass list to query.setArgs(), I
get below exception
If I pass single value to setArgs, it works fine.
BUt it does not accept list/array of values.

Failed to execute query.......
Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting
"'[2, 3, 5]' (ID BIGINT)"; SQL statement:
SELECT
C._KEY __C0,
C._VAL __C1
FROM TABLE(ID BIGINT=?1) I 
 INNER JOIN "companies".COMPANY C
WHERE C.ID = I.ID [22018-175]

I changed list to list.toArray(), below exception is thrown"
Caused by: org.h2.jdbc.JdbcSQLException: Invalid value "2" for parameter
"parameterIndex" [90008-175]




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Getting-exception-in-SQL-Query-JOINS-tp6674p6735.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message