I recently experienced an issue where in if I coded
@org.hibernate.annotations.Cascade({org.hibernate.annotations.CascadeType.DELETE_ORPHAN } ) for a parent class, hibernate first tries to delete the child and grand child classes and thus throws the ORA-02292: integrity constraint violated: child record found. can somebody please let me know as to what annotation should be there for

PARENET Class
|
|
|

Child Class(Joined by PARENT_ID)
|
|
|
Grand child class(Joined by CHILD_ID)

Thanks!