Deleting a record that has children - Oracle 8i and JBoss 3.0.0

Discussions

EJB programming & troubleshooting: Deleting a record that has children - Oracle 8i and JBoss 3.0.0

  1. The app server I am using is JBoss 3.0.0.
     I have an entity A bound to table A in Oracle 8i and I also have an entity B bound to table B inside the database. The relation between entity A and entity B is one to many. Inside the database there is a Constraint on table B like: type=Referential Integrity,column=A_ID,deleteRule=NO ACTION,refConsName=PK_A. Due to this rule if I try to delete a record from table A that is referenced in table B using an Oracle client I get an exception like "ORA-02292: integrity constraint (NAME OF THE CONSTRAINT) violated - child record found". So far so good. My problem is that if I try to delete the same record from my application I don't get any exception and the record is deleted. What can be that I have set wrong and I cannot found.
    Thanks for the replies.
  2. maybe you have cascade delete set to true