A : parent entity
B: child entity.
Analysis code : entity
c is an attribute in B, composition one to many. , analysisCode.
whenever there is an attribute in child class which is composition,
we face sql integrity constraint violation , foreign key no parent error.
SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no parent; FK_EMS_ANALYSIS_CODE_ON_PARENT table: EMS_ANALYSIS_CODE
how to overcome this ?
Could you describe the case in mode details please? Please share demo project to investigate the problem if possible
Demo project for clarification.
- entity Organization : parent hierarchy : joined
- entity Orgunit : child class of organization.
- entity branch. attribute in org unit : compostion
- entity location : association in all entities listed above.
when i try to create Orgunit along with branches and save it, i get this sql integrity error, foreign key no parent
the project folder is big even after zip, will try to scale down further and upload sample project.
You can run the following Gradle task to compile project archive:
Thank you so much for the response.DemoSql.zip (95.9 KB)