With a List of PKs (Integers), I'd like to delete a bunch of records without loading them into the session.

session.delete("from Result result where result.id in (:ids)", resultids, Hibernate.INTEGER);
gives me a ClassCastException

Query q = session.createQuery("from Result result where result.id in (:ids)");
q.setParameterList("ids", resultids, Hibernate.INTEGER);
session.delete(q.getQueryString());
tells me the parameter isn't specified.

What am I doing wrong?

Thanks for any tips:)

Hibernate does not currently (ever?) support mass updates or deletes. We have discussed many times the problems with this.

I spent my whole life trying not to be careless. Women and children can be careless. But not men.