Hibernate version: 2.1.4

I have two entity classes:
EntityA and EntityB.
EntityA refer to EntityB as many-to-one.

1) I delete EntityB from Database (passing over hibernate)
2) I try to get EntityA
3) I get:


How I can avoid this exception. I want to get null instead of NPE.

Thanx.

try using session.get(..) instead of session.load(...)

I'm using get(..) method

Don't you have a foreign key constraint on the column that holds the reference from EntityA to EntityB?

1. If you have it - then you can't delete EntityB without setting the column to
NULL.
Please note that there could be problems even with this approach, when using the second level cache.
(i.e the second level cache for entityA still holds a cached record, from when the instance held the relation to entityB,
but the instance that is referenced (of EntityB) is not in the cache -
hibernate will resolve entityA in the cache, and will try to load entityB from the database (cache miss) and will throw and ObjectNotFoundException.

I guess you can always catch:
try{
result = session.load(EntityA.Class, '123');

}catch(ObjectNotFoundException){
session.setCacheMode(CacheMode.REFRESH;
result = session.load(EntityA.Class, '123');
session.setCacheMode(CacheMode.NORMAL);
}

2. If you don't have a foreighn key constraint - I don't know a way to get rid of this problem. You really should set one...