Finally,I edit the source code org.apache.ignite.springdata20.repository.query.IgniteRepositoryQuery prepareQuery method. In it ,treat 'IN ?' to 'IN (?,?)' ,also the parameters flatten. that seems ok.
在 2019-12-19 21:53:47，"Ivan Pavlukhin" <[email protected]> 写道： >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
