Hibernate HQL Query How to set a Collection as a named parameter of a Query

Question

Given the following HQL Query   FROM     Foo WHERE     Id    id AND     Bar IN   barList    I set  id using the Query object s setInteger   method    I would like to set  barList using a List of objects  but looking at the Hibernate documentation and list of methods I cannot see an obvious choice of which to use  Any ideas

User · Accepted Answer

Use Query setParameterList    Javadoc here   There are four variants to pick from

User · Answer

I m not sure about HQL  but in JPA you just call the query s setParameter with the parameter and collection   Query q   entityManager createQuery  SELECT p FROM Peron p WHERE name IN   names     q setParameter  names   names     where names is the collection of names you re searching for  Collection lt String gt  names   new ArrayList lt String    names add  Joe    names add  Jane    names add  Bob

User · Answer

In TorpedoQuery it look like this  Entity from   from Entity class   where from getCode    in  Joe    Bob    Query lt Entity gt  select   select from

[java] Hibernate HQL Query : How to set a Collection as a named parameter of a Query?

Examples related to java

Examples related to hibernate

Examples related to hql