How to correct create JPQL request?

Question

I have repository method:

@Query(value = "select t from Transaction t " +
        "where t.bankAccountId in (:bankAccountIds) " +
        "and t.tradeTime is not null " +
        "and t.ccy is not null " +
        "and t.net is not null " +
        "and t.tradeTime >= :startDate and t.tradeTime <= :endDate " +
        "and t.status = :status")
List<Transaction> findAllByBankAccountIdInAndTradeTimeBetween(@Param("bankAccountIds") Iterable<UUID> bankAccountIds,
                                                              @Param("status") TransactionStatus status,
                                                              @Param("startDate") LocalDateTime startDate,
                                                              @Param("endDate") LocalDateTime endDate);

But when I tried to use this code I have exception:

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"

How to fix it?

Does this answer your question? [JPQL IN clause: Java-Arrays (or Lists, Sets...)?](https://stackoverflow.com/questions/2772305/jpql-in-clause-java-arrays-or-lists-sets) — Eric Citaire, Sep 03 '20 at 12:40
You need to pass in a `List`, and use the correct syntax is `IN :bankAccountIds`. — Eric Citaire, Sep 03 '20 at 13:07
You may an empty argument List so you end up with `...IN ()....` — vsfDawg, Sep 03 '20 at 13:15
Add full stacktrace of the exception after removing bracket. — Eklavya, Sep 03 '20 at 13:40

score 0 · Answer 1 · answered Sep 03 '20 at 12:30

0

I think you don't need the brackets (:bankAccountIds)

answered Sep 03 '20 at 12:30

hecko84

1,224
1
16
29

i have another methods where there is brackerts and it works – Krazim00da Sep 03 '20 at 12:32
Is it receiving a single value or a list? – rascio Sep 03 '20 at 12:34
receiving a list – Krazim00da Sep 03 '20 at 12:36
Have you tried to use a List instead of the Iterable? – hecko84 Sep 03 '20 at 12:53

How to correct create JPQL request?

1 Answers1