It's a parent/child association, and I set the mapping as "all, delete-orphan".When I delete the parent(session.delete(parent);), it produces many sql such as:
delete from child where id=?
delete from child where id=?
...
delete from parent where id=?

but my purpose is to use just 2 sql such as:
delete from parent where id=?
delete from child where parent_id=?

How can I do that?

thanks