Hibernate version: 3.1.1

Hello there! I have three entities:

Subscriber
Product
Package

Subscriber has a one-to-many relationship to Product (mapped as a Set)
and Product has a many-to-one relation ship to packate Package


What's happening (Ok I'm affraid it might be an constraint violation of the DB, but please read on...)
Subscriber has 3 products 2 of them have a corresponding row on the Package table, a third one does not.

Well, hibernate is throwing an ObjectNotFoundException. My question is shouldn't it be using get instead of load for this relationship? I'd like to have a partial filled collection instead an error, what could be done to solve this?

Regards

Hi,

Sounds like you have a database problem there.

My solution:

Unmap de many to one relation, simply map the packageId as a Long or String or whatever it is in Product class.

Package package= (Package) hibernateSession.get(Package.class, product.getPackageId());
if (product.getPackageId() != null && package== null) {
// log if database inconsistency
logger.warn("You just discovered a database inconsistency");
}

If your case the result should be:

1 Subscriber
3 Product
2 Package
1 warn message

For more help pls ask.