How to query from a date list in JPA?

Question

I am trying to query all the transactions happened from a list of dates.So I tried the below function:

 public Collection<Transaction> getTransactionsByDates(short status,List<Date> dates){
   Query query = em.createQuery(" SELECT a FROM Transaction a where a.Status=:status and a.dates in :transactionDate");
   query.setParameter("status", status);
   query.setParameter("dates", dates);
   return (Collection<Transaction>) query.getResultList();
}

But this throws the error of

org.hibernate.QueryException: could not resolve property: dates

Am I querying in JPA properly?

Any help is appreciated!

seems like there is issue in setting the parameter . Change this query.setParameter("date", dates); to query.setParameter("transactionDate", dates); — Harmandeep Singh Kalsi, Jul 07 '20 at 06:36
You wrote `:transactionDate` but then you try to replace the parameter `dates`. Try to change `:transactionDate` in `:dates`. You may also need to use parenthesis around the list `(:dates)` — FaltFe, Jul 07 '20 at 06:37

score 1 · Accepted Answer · answered Jul 07 '20 at 06:35

I think there is typo

public Collection<Transaction> getTransactionsByDates(short status,List<Date> dates){
   Query query = em.createQuery(" SELECT a FROM Transaction a where a.Status=:status and a.dates in :transactionDate");
   query.setParameter("status", status);
   query.setParameter("transactionDate", dates);
   return (Collection<Transaction>) query.getResultList();
}

Rahul Kumar · Answer 2 · 2020-07-07T07:11:27.347

0

Replace line

query.setParameter("dates", dates);

with

query.setParameter("transactionDate", dates);

typo issue

edited Jul 07 '20 at 07:11

answered Jul 07 '20 at 06:49

Rahul Kumar

362
1
7

How to query from a date list in JPA?

2 Answers2