CODEWITHSUNDEEP
javahibernateforeign-keysforeign-key-relationship
cometta
cometta

Reputation: 35719

delete entity that map with another entity

entity A --> id, entity_a_name, foreign_key_entity_B entity B ---> id, entity_b_name

when i delete entity B record, it suppose to auto delete entity A that has foreign_key_entity_B ?

Error: ORA-02292: integrity constraint (schema.FKA630D2FB5F0F1180) violated - child record found

Upvotes: 0

Views: 266

Answers (1)

NickDK
NickDK

Reputation: 5207

Well most Oracle databases I've seen don't auto-delete child records or anything. So you should delete all child records before you can delete you parent record.

Upvotes: 1

Related Questions