My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.