Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] Support required for an eclipselink issue

Hi Team,

 

We have upgraded from Ecipselink 2.1.3 to 3.0.2 and we are facing following issue in the application. There is a scenario in the application to delete entries in multiple tables, which has foreignkey references. It should delete entries in child tables and then delete the entry in parent table, but in new version it is directly deleting in parent table entry before child table. It is throwing below exception from unitofwork.writeChanges();

 

It was working fine in the previous version (2.1.3) but not in 3.0.2. Looking for your support on this.

 

Error Code: 2292

Call: DELETE FROM EMPLOYEE WHERE (EMP_ID = ?)

        bind => [1 parameter bound]

Query: DataModifyQuery(name="_outboundDialedDigits" sql="DELETE FROM EMPLOYEE WHERE (EMP_ID = ?)")

Exception [EclipseLink-4002] (Eclipse Persistence Services - 3.0.2.v202107120736): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (SYSADM.FK_CHL_CONSTRAIN) violated - child record found

 

Thanks,

Vijay.

 

 

 

 


Back to the top