Hello,

I have a parent-child relationship between ResultSet and KPI. But don't want to cascade a deletion of a ResultSet to the child KPIs, so this property is not set in the mapping.

I get an ObjectNotFoundException when the following occurs:

*delete ResultSet "TestRs" with ID = 101
*had existing KPI which had reference to "TestRs"; i.e. the ResultSetId column in the KPI table still had ID 101, but this ResultSet no longer exists
*when attempt to retrieve list of KPIs, get ObjectNotFoundException thrown

KPI


So KPI has a reference to its parent ResultSet.


The KPI mapping is as follows:



The KPI table has columns ID, Label, and ResultSetId.

When the ResultSet in question is deleted (the one w/ id 101), the ResultSetId column in the KPI table still references 101, as expected. HOWEVER: is there a way to make this a non-exception, somehow indicate that ResultSetId might refer to a deleted ResultSet?

Thanks,
Alex

Sorry, subject should have read "...exception when delete parent" NOT child

No, Hibernate must be based on a proper relational usage. You can however not map the association (only the id) and link it manually.