Hi, I tried a named parameter and indeed it does not work. Actually, @Query annotation is an Ignite custom one. Subsequently @Param annotation is not supported, consequently named arguments and list arguments do not work =(
чт, 19 дек. 2019 г. в 16:52, shishkovilja <[email protected]>: > > Unfortunately, code placed at this link doesn't work, it throws an exception > same as yours. I have made changes in reply at Nabble, so you haven't see > attached exception: > > Caused by: org.h2.jdbc.JdbcSQLException: Синтаксическая ошибка в выражении > SQL "SELECT ""PersonCache"".""PERSON""._KEY, ""PersonCache"".""PERSON""._VAL > FROM PERSON WHERE SALARY IN (:[*]SAL) "; ожидалось "NOT, EXISTS, INTERSECTS, > SELECT, FROM, WITH" > Syntax error in SQL statement "SELECT ""PersonCache"".""PERSON""._KEY, > ""PersonCache"".""PERSON""._VAL FROM PERSON WHERE SALARY IN (:[*]SAL) "; > expected "NOT, EXISTS, INTERSECTS, SELECT, FROM, WITH"; SQL statement: > SELECT "PersonCache"."PERSON"._KEY, "PersonCache"."PERSON"._VAL FROM Person > WHERE salary IN (:sal) [42001-197] > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Best regards, Ivan Pavlukhin
