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