Remove in EJB Does not Delete 1:N Relations and Throws Error ORA-1407
(Doc ID 388290.1)
Last updated on JUNE 29, 2021
Applies to:Oracle Containers for J2EE - Version 188.8.131.52.0 to 10.1.2.0.2 [Release AS10g to AS10gR2]
Information in this document applies to any platform.
When two Entity Beans to implement master-detail relationship and define the relationship to
implement "cascading delete", on OC4J 9.0.4.X and 10.1.2.X you get errors:
The problem reproduces
- when removing an instance of the "master" bean
- even if the tables on the database do not implement a foreign key
- when the foreign key is NOT NULL column as a results of the relationship being mandatory
- even if the relationship has < cascade-delete/ > added
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document