HQL; List of Integer as input query

Question

I have a List composed by Integer elements. I have to make a single query like this:

 From Table as t where t.id <> element1 AND t.id <> element2 AND ......

Someone can give me a tip how to set the input list? I have to set the single element or the entire list?

Community · Accepted Answer · 2017-05-23 11:44:25Z

4

Create Collection of Integers:

Collection<Integer> ints = new ArrayList<Integer>();
ints.add(1);
ints.add(2);
ints.add(3);

Set it as parameter:

Query q = entityManager.createQuery("FROM Table as t WHERE t.id NOT IN (:ints)");
q.setParameterList("ints", ints);

CommunityBot

11 silver badge

answered Aug 19, 2016 at 8:41

Rudziankoŭ

11.3k27 gold badges114 silver badges217 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ehy thank's it worked! (but i had to use setParameterList instead the simple setParameter). However it's solved now, thx ^^

Thanks! Improved my answer