I have a object "Person" which is linked one-to-many with some "Contracts" objects and i use the Criteria API to initialize them.

If I use the API like it, the objets are well preloaded and it is ok:

In this case, hibernate generate an left outer join in the query and i can access the contracts collection after closing the hibernate session.

But if i add a restriction in the query like this:



In this case, hibernate generate an inner join in the query, and when i access the contracts collection after closing the hibernate session, i get a LazyInitializationException.

Any idea ?

PS: I don't want to define lazy loading properties in my xml files, cause i want to define lazy loading in the code with something like "setFetchMode("contracts",FetchMode.JOIN)".

:/.

Have you tried the below code?

This will fetch all the Person objects who have contracts.endDate != null.
Since the Person to Contracts is a one-to-many collection, if you access contracts through the person object all the contracts of the person will have to be loaded. And since the session is closed LazyInitializationException will be thrown.

This should work:

Thanks for answers, but it doesn't seem to be nether a createCriteria(String,int) method in the hibernate 3 API, nor a Criteria.LEFT_JOIN attribute.

You are right, createCriteria( String, int ) was introduced in hibernate version 3.1 only and not available in hibernate versions 3.0.x