Hibernate 4.1.11 hql delete query with where in list

Question

I want to delete from a table some entries with specific ids. I want to know the syntax of this request

delete from table where id in list_of_ids

in hql.

Answer 1

Assuming the id of your table is of type Long, the correct way to perform the delete is as follows:

List<Long> ids = new ArrayList<Long>();
ids.add(1L);
ids.add(2L);

Query q = session.createQuery("DELETE FROM YourEntityName ye WHERE ye.id IN (:list)");

q.setParameterList("list", ids);
q.executeUpdate();