Lazy load not working

Guest · **Posted:** Wed May 18, 2005 4:08 pm

Hi all,

I am having some pretty severe problems with lazy loading. Basically, none of my collections are being loaded lazily when speciified. Several of my classes have several collections. Here is an example of my mappings, other association mappings in the classes are omitted for clarity:

The 'one-to-many' class:

Code:

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" default-access="field">
<class name="Case,Api" table="Case">
      <id name="caseID" column="caseID" type="Int32" unsaved-value="0">
         <generator class="native" />
      </id>
<set name="issues" inverse="true" lazy="true" cascade="all-delete-orphan">
<key column="caseID" />
<one-to-many class="Issue, Api" />
</set>
</hibernate-mapping>

The many-to-one class:

Code:

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" default-access="field">
   <class name="Issue,Api" table="Issue">
      <id name="caseIssueID" column="caseIssueID" type="Int32" unsaved-value="0">
         <generator class="native"/>
      </id>
      <many-to-one name="Case" column="caseID" class="Case,Api" />
</hibernate-mapping>

This is how I map most of my collections. As I said, none of them are being lazy loaded. Any help would be much appreciated as I wil be running into performance issues if I can't get this fixed. I am using version 0.8.2. Outer join fetching is set to false in my web.config file as default.

Many thanks,
Tony

sergey · **Posted:** Wed May 18, 2005 5:15 pm

It would help a lot if you could configure log4net to log at least at INFO or DEBUG level, and post the relevant parts of the log here. Your mappings look right at a glance.

Tony W · **Posted:** Thu May 19, 2005 10:50 am

Hi Sergey,

Which parts of the mapping file in particular? The SELECT statements for the Case and its many associated collections go on for a considerable number of lines in the log. Should I be using 'proxy' on the target class perhaps?

KPixel · **Posted:** Thu May 19, 2005 11:02 am

Post informations about the test you run to see if lazy-loading works (C# files and the content of your log file).

Guest · **Posted:** Thu May 19, 2005 12:32 pm

Guys, thanks for the replies but I've just realised that I don't have a problem after all. I'd checked the variables in the debugger while the session was still open, hence I came to the conclusion that the collections were not being loaded lazily. When I came to my senses and checked the returned object in the presentation tier through the debugger, I get the exceptions I expect. The reason I hadn't noticed this earlier is that my app isn't set to attempt to load any of the lazy collections yet! I blame three weeks without a day off and working 14 hours per day! And no, I don't work for EA before anybody asks!! :wink:

Tony W · **Posted:** Thu May 19, 2005 12:45 pm

Anonymous wrote:

Guys, thanks for the replies but I've just realised that I don't have a problem after all. I'd checked the variables in the debugger while the session was still open, hence I came to the conclusion that the collections were not being loaded lazily. When I came to my senses and checked the returned object in the presentation tier through the debugger, I get the exceptions I expect. The reason I hadn't noticed this earlier is that my app isn't set to attempt to load any of the lazy collections yet! I blame three weeks without a day off and working 14 hours per day! And no, I don't work for EA before anybody asks!! :wink:

Sorry, hadn't logged in there. Thanks again, I definitely need more sleep.... :shock: