How to make Hibernate automatically delete orphaned entity association records

There is a way. You just execute a DML query like this DELETE FROM Intestatario i WHERE i.propostas IS EMPTY which will delete all Intestatario that have no propostas assigned. This assumes you have the inverse mapping as well though. You can write the query the other way as well by using a subquery, but I don’t know your exact model.