Adding IN clause List to a JPA Query

Question

I have built a NamedQuery that looks like this    NamedQuery name    EventLog viewDatesInclude           query    SELECT el FROM EventLog el WHERE el timeMark  gt    dateFrom AND              el timeMark  lt    dateTo AND              el name IN   inclList      What I want to do is fill in the parameter  inclList with a list of items instead of one item   For example if I have a new List lt String gt       a    b    c    how do I get that in the  inclList parameter   It only lets me codify one string    For example   setParameter  inclList    a      works  setParameter  inclList    a  b      does not work  setParameter  inclList     a    b       does not work  setParameter  inclList   list     throws an exception   I know I could just build a string and build the whole Query from that  but I wanted to avoid the overhead    Is there a better way of doing this   Related question  if the List is very large  is there any good way of building query like that

User · Accepted Answer

When using IN with a collection-valued parameter you  don t need          NamedQuery name    EventLog viewDatesInclude        query    SELECT el FROM EventLog el WHERE el timeMark  gt    dateFrom AND           el timeMark  lt    dateTo AND           el name IN  inclList

User · Answer

public List lt DealInfo gt  getDealInfos List lt String gt  dealIds            String queryStr    SELECT NEW com admin entity DealInfo deal url  deal url  deal url  deal url  deal price  deal value       FROM Deal AS deal where deal id in  inclList           TypedQuery lt DealInfo gt  query   em createQuery queryStr  DealInfo class           query setParameter  inclList   dealIds           return query getResultList            Works for me with JPA 2  Jboss 7 0 2

User · Answer

The proper JPA query format would be   el name IN  inclList   If you re using an older version of Hibernate as your provider you have to write   el name IN   inclList    but that is a bug  HHH-5126   EDIT  which has been resolved by now

User · Answer

You must convert to List as shown below       String   valores   hierarquia split                  List lt String gt  lista    Arrays asList valores        String jpqlQuery    SELECT a                  FROM AcessoScr a                  WHERE a scr IN  param         Query query   getEntityManager   createQuery jpqlQuery  AcessoScr class                          query setParameter  param   lista            List lt AcessoScr gt  acessos   query getResultList

[java] Adding IN clause List to a JPA Query

Examples related to java

Examples related to jpa

Examples related to jpql