Remove in EJB Does not Delete 1:N Relations and Throws Error ORA-1407
(Doc ID 388290.1)
Last updated on JUNE 02, 2023
Applies to:
Oracle Containers for J2EE - Version 9.0.4.2.0 to 10.1.2.0.2 [Release AS10g to AS10gR2]Information in this document applies to any platform.
Symptoms
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |