I am new to Hibernate, cannot find the simple documentation of how to remove multiple entities at once. I see I can use entityManager.remove(Object obj), but if I have a collection (ie: I can query a list) I would rather not loop through and make a delete call on each individual id.

I can use native sql as it is a simple call, but is that advised, meaning will that make the Hibernate interface out of sync. I am just looking for the best way to do a simple mass delete by id to a table.

Thank you so much, sorry for the simple question, but google and api don't seem to be helping.

msj121

I found on the iirc the following, "odin_" helped me out:

Item item = session.get(Item.class, Integer.valueOf(id));
Query q = session.createQuery("DELETE FROM " + com.msj.entities.CategoryMap.class.getName() + " WHERE item=?");
q.setEntity(0, item);
q.executeUpdate();