How can I make sql generated by Hibernate use in operators over equality operators

Question

What I want is a way for Hibernate to generate 1 statement to delete all children, instead of 1 statement per child.

If I have a relationship between Entity A and B , where A is the parent and B can be many children. If I use annotations such as OrphanRemoval or OnCascade delete on the entity relationship, when I delete the parent the sql that gets automatically generated says

delete from table where id=?  - per child

What I want Hibernate to do is generate sql like

delete from table where id in (child1,child1)

Is there an annotation or setting I can use to do this easily?

I feel I'm not the first person to run into this issue, but I cant find any way to solve it other then writing my own sql and removing the annotations.

Answer 1

You can't do that with entityManager.remove() but you can use executeUpdate():

Query q = entitiyManager.createQuery("delete from MyEntity m where m.id in :ids)");
q.setParameter("id", <list of ids>);
q.executeUpdate();

Read more in the documentation: https://docs.jboss.org/hibernate/orm/current/userguide/html_single/Hibernate_User_Guide.html#batch-bulk-hql-update-delete