How to set list of values as parameter into hibernate query?

Question

For example, I have this query

 select cat from Cat cat where cat.id in :ids

and I want to set ids to list (1,2,3,4,5,6,17,19).

This code doesn't work

session.createQuery("select cat from Cat cat where cat.id in :ids")
       .setParameter("ids", new Long[]{1,2,3,4,5})

As the result I would like to have SQL query like id in (1,2,3,4)

Alin Pandichi · Accepted Answer · 2016-08-09 14:10:38Z

60

Use setParameterList(). You'll also have to put parenthesis around the list param.

session.createQuery("select cat from Cat cat where cat.id in (:ids)").setParameterList("ids", new Long[]{1,2,3,4,5})

Alin Pandichi

9555 silver badges16 bronze badges

answered Jul 5, 2011 at 15:14

sblundy

61.5k22 gold badges124 silver badges124 bronze badges

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

2 Comments

setParameterList is depcreated in newer hibernate. How do we pass this in? I tried using setparameter and didn't get correct behavior...

yes setParameterList is deprecated and i could not get correct behavior too, any update?