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?

score 93 · Accepted Answer · edited Apr 01 '11 at 12:47

93

Use Query.setParameterList(), Javadoc here.

There are four variants to pick from.

edited Apr 01 '11 at 12:47

Baztoune

1,225
1
16
20

answered Feb 20 '09 at 16:40

Jason Cohen

75,915
26
104
111

Thank you for pointing this out! I completely overlooked this when looking at the the JavaDoc. – karlgrz Feb 20 '09 at 17:01
2

D: Oh noes, broken link (...painfully typical of the JBoss docs) – Matt Ball Sep 15 '10 at 19:22
2

That only works if you are using a hibernate Query object, but won't work if you import `javax.persistence.Query`. Just my two cents. – Niel de Wet Oct 14 '13 at 20:21

score 33 · Answer 2 · answered Feb 20 '09 at 16:33

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<String> names = new ArrayList<String();
names.add("Joe");
names.add("Jane");
names.add("Bob");

score 1 · Answer 3 · answered Nov 01 '11 at 02:25

1

In TorpedoQuery it look like this

Entity from = from(Entity.class);
where(from.getCode()).in("Joe", "Bob");
Query<Entity> select = select(from);

answered Nov 01 '11 at 02:25

xjodoin

469
4
14

7

How does that answer the question? Please don't post links to your project if they don't address the problem directly. – Mat Nov 01 '11 at 11:03
1

It generate an hql query with a in condition – xjodoin Nov 01 '11 at 17:19

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

3 Answers3

Linked