Hibernate version: 3.2.5.ga
There is
a bug with @SQLDeleteAll, which is claimed as
fixed in 3.3.0.ga.
Unfortunatelly our application is in production already and we can not upgrade to the newer hibernate easily.
Indeed, the problem we experience appears only when deleting last item in the collection, when there is at least one item left Hibernate calls our custom @SQLDelete and it works well for us.
Is there any way to force Hibernate to not "optimize" deletion of all items from collections and always delete row by row with SQLDelete?