How to handle failed CMR relationship?

cvandyck Jan 28, 2004 10:39 AM

"cvandyck" wrote:
I've got a situation where it's possible for various reasons for my entity database to become corrupted.

For example, I have an entity A which has a CMR to B using foreign key a2b. After the database corruption, the key a2b points to a record that no longer exists.

When I try and load this entity, I get a NoSuchObjectLocalException thrown. I would like to be able to instead assume that if the entity on the other end of the CMR does not exist, to return NULL for that relationship.

Is this possible? I'm using JBoss 3.2.2. It seems to me that the only way that I can recover from this is to manually change records in the database, or do the same programatically using JDBC.

Many thanks.
Collin

1. Re: How to handle failed CMR relationship?

darranl Jan 28, 2004 11:52 AM (in response to cvandyck)

"darranl" wrote:
My first sugestion would be to correct the situation that is causing the database corruption, if you are hiding an integrity issue how are you going to be able to tell if something has really gone wrong.
Actions
2. Re: How to handle failed CMR relationship?

cvandyck Jan 28, 2004 12:33 PM (in response to cvandyck)

"cvandyck" wrote:
Fixing what is causing the corruption is certainly being looked into. However, I still want to be able to recover from this situation.

Any ideas?
Actions

Go to original post