Lazy load association not working

amemon · **Joined:** Thu Dec 01, 2005 12:53 am **Posts:** 21

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.2

I have following hibernate mapping,

Code:

<hibernate-mapping default-lazy="false">

   <class name="User" table="user">
      <id name="id" column="id">
         <generator class="native" />
      </id>

      <property name="username" column="username" length="120" />
      <property name="lastName" column="last_name" length="60" />
      <property name="firstName" column="first_name" length="60" />
      <property name="emailAddress" column="email_address" length="120" />
      <set name="rights" table="user_right" lazy="true">
         <key column="nimax_user_id" />
         <element column="right_name" type="string" />
      </set>
</hibernate-mapping>

Whenever I load the user object .... the "rights" association gets read always. I have lazy="true" but it seems not working. Can anyone suggest me what to do to make "rights"association lazy load?

kochcp · **Posted:** Mon Apr 17, 2006 2:35 pm

how are you loading it

amemon · **Joined:** Thu Dec 01, 2005 12:53 am **Posts:** 21

Code:

User user = User.findUserForUsername("super");

Hibernate.getSession().load(User.class, new Long(1));

In both of the above ways .... hibernate does two queries ... one to read the user and other immediatly after it to read its "rights" associtation.

damnhandy · **Posted:** Tue Apr 18, 2006 6:55 am

So you're if you are executing both:

Code:

User user = User.findUserForUsername("super"); 

Hibernate.getSession().load(User.class, new Long(1)); 

And if the User.findUserForUsername() method executes an HQL, SQL, or Criteria query that returns a user, then Hibernate will executing two queries:

Session.load() will execute a SQL query to load the entity by identifer.

Ryan-

DWright · **Joined:** Wed Jul 07, 2004 2:00 pm **Posts:** 64

lazy=true has been working for me. I don't know about your User.findUserForUsername("super"); without seeing the underlying code, but the session.load has always worked for me. Are you sure that you aren't doing a toString or something else after the load that causes the lazy relationship to be instantiated? Maybe try a println of Hibernate.isInitialized(user.getRights()) right after the load?

amemon · **Joined:** Thu Dec 01, 2005 12:53 am **Posts:** 21

Hi damnhandy,

regarding you post .... you took it the wrong way - I mean to say was ... in any case either through finder which uses Query interface or using the session.load ... the hibernate always reads the "rights" association as another sql query. The lazy="true" on "rights" association seems to be not working for me :(

damnhandy · **Posted:** Wed Apr 19, 2006 7:06 am

I see, so either with a query or Session.load(), the assocaition is eagerly loaded. I did notice one thing however, the root of your mapping file specifies:

Code:

<hibernate-mapping default-lazy="false">

The default value for default-lazy is "true", I would suggesst that you remove that attribute from here and use the defaults. I have never set this attribute at the root level so I can't comment on it's behavior, but it would appear that this could overriding the lazy attribute on the rights association?

Ryan-