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

Viewed 47641

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)

1 Answers
Related