Hi all,
I am new to hibernate ad stuck up in LazyInitializationException

I have a relationship like this:

Organization {

/**one-to-many*/
Set dept; // of type Departments

}

Departments{

/**many-to-one */
Organization organization

/**many-to-one */
Activity activity;
}

Activity{

/** one-to-many */
set departments

/**many-to-one*/
ActivityDetails details;

}

ActivityDetails {
String venue;

}

All relations are non-lazy.


Given an organization, I want to fetch all activities and ActivityDetails associated with it.

My HQL is

"from Departments as dept where dept.organisation.name = ? "

I get all activities and related Activity details in my Junit tests.
However when I deploy same code in tomcat and try to fetch activity and details,
I get LazyInitializationException....at follwing statement
details = department.getActivity().getDetails();


However if i change my query to

from Departments as dept left join fetch dept.activity act left join fetch act.details details where spon.organisation.name = ?


the code passes thru unit test as well as on the server.


I don't understand how is it possible that old query code runs thru properly in unit test environment but fails on tomcat?

Mebbe in your unit test, you have the session open till you access activity details. In production code, are you trying to retrieve the details outside the scope of session? In that case, we might encounter the LazyInitializationException.

Regd outer join, it will eagerly fetch the collection / association, so we will not encounter the lazy .. exception.

Thanks for the reply.
You are correct.
I am usign Unitils test framework in which by default each test runs in its own transaction overriding any trasaction configurations present in classpath.
However, when i made the test case to be @Transactional(TransactionMode.DISABLED) I started getting same exception even in my test case.
Now about the second part: Why it failed on webapp
Well my target bean was configured to have "PROPAGATION_REQUIRED" only for update and delete and not for read which caused the exception on get*** methods.

<property name="transactionAttributes">
<props>
<prop key="store*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
</props>
</property>