Problem with Lazy loading of hierarchical data with spring

[Ranjeet Kr Jha]

Hi,

we are facing with lazy loading in spring framework, we don't know where we are doing silly mistake. Code of all the layer are as below, please suggest what should we do. When we access siteManager object from siteManagerSite in service layer, we get some value but the same thing is not retrieved in controller class, throwing LazyInitializationException. If we access siteManger obejct in Dao/service class or put Hibernate.initialize(sms.getSiteManager()) code either in service or dao layer then we are able to get siteManager object in controller, I think puting this code in service or dao layer is not the solution of loading lazily. there is no SiteManager.hbm.xml in our application, its mapped as below by joined-subclass in related object. Please help me, how to retrieve/load the siteManager in controller class.

dataAccess.xml
==============

<!-- Hibernate sessionFactory bean and mappings -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSes sionFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<<and other configuration related to this>>
</bean>

<bean name="openSessionInViewInterceptor" class="org.springframework.orm.hibernate3.support. OpenSessionInViewInterceptor">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
<!--<property name="flushModeName"><value>FLUSH_AUTO</value></property> à
</bean>

application-servlet.xml
=======================
<bean id="handlerMapping" class="org.springframework.web.servlet.handler.Sim pleUrlHandlerMapping">
<property name="interceptors">
<list>
<ref bean="openSessionInViewInterceptor"/>
<!--<ref bean="hibernateInterceptor"/>-->
</list>
</property>
<property name="mappings">
<props>
<prop key="/secure/site/*">siteController</prop>

</props>
</property>
</bean>


<bean id="siteServiceTarget" class="com.abc.svc.SiteServiceImpl">
<property name="siteDao">
<ref local="siteDao"/>
</property>
</bean>

<bean id="siteService" class="org.springframework.aop.framework.ProxyFact oryBean">
<property name="target">
<ref bean="siteServiceTarget"/>
</property>
<property name="proxyInterfaces">
<value>com.abc.svc.SiteService</value>
</property>
<property name="interceptorNames">
<list>
<value>hibernateInterceptor</value>
</list>
</property>
</bean>
<bean id="siteDao" class="com.abc.dao.SiteDaoHibernateImpl">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>

<bean id="hibernateInterceptor" class="org.springframework.orm.hibernate3.Hibernat eInterceptor">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>

controller class code
====================
		
		//Get SiteManagerSite for SiteManager Object by SiteId.
		SiteManagerSite siteManagerSite = siteService.getSiteManagerSiteBySite(site.getId());
		
		LOG.debug("siteId : " + siteManagerSite.getSite().getId());
		LOG.debug(siteManagerSite.getSiteManager().getUsername());
		
		String siteManagerEmail = siteManagerSite.getSiteManager().getEmail();
process something... with emailId
		// Send mail notification to SiteManager
		SendMail(.....);
		
	}

service class
=============

public SiteManagerSite getSiteManagerSiteBySite(Long siteId) {
		LOG.debug("Getting SiteManagerSite with site id: "+siteId);
		SiteManagerSite sms = this.siteDao.getSiteManagerSiteBySite(siteId);
		//Hibernate.initialize(sms.getSiteManager());
		//LOG.debug(sms.getSiteManager().getEmail());
		
		//return this.siteDao.getSiteManagerSiteBySite(siteId);
		return sms;
	}

DAO Class code
=========
public SiteManagerSite getSiteManagerSiteBySite(Long siteId) {
		LOG.debug("Getting SiteManagerSite for site with id: " + siteId);
		SiteManagerSite sms = (SiteManagerSite) getHibernateTemplate().find(
				"from SiteManagerSite as sms where sms.site.id = ?", siteId).get(0);

		// Hibernate.initialize(sms.getSiteManager());

		return sms;
	}

siteManagerSite.hbm.xml
===============
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
    <class name="com.abc.domain.dto.SiteManagerSite" table="site_manager_site" >
        <id name="id" type="java.lang.Long">
            <column name="site_manager_site_id" />
            <generator class="native" />
        </id>
        <many-to-one name="site" class="com.abc.domain.dto.Site" fetch="select" column="site" not-null="true" unique="true" cascade="save-update" />
        <many-to-one name="siteManager" class="com.abc.domain.dto.SiteManager" fetch="select" column="site_manager" not-null="true" cascade="save-update" />
        
        <property name="payAmount" type="big_decimal" column="pay_amount" not-null="true"/>
        ...
    </class>
</hibernate-mapping>


SiteManger domain object mapped in another hbm.xml is as :

<joined-subclass name="com.abc.domain.dto.SiteManager" table="site_manager">
            <key column="user_id"/>
	        <!-- TODO: remove the lazy -->
			<many-to-one name="homeAddress" class="com.abc.common.domain.dto.Address" fetch="select" unique="true" cascade="all" column="home_address" not-null="true" lazy="false" />
	      <property name="gender" type="com.abc.common.enumeration.hibernate.GenderUserType" column="gender" length="6" not-null="true" />
        	....
        </joined-subclass>

[Amit Ghorpade]

"jr kr " please check your private messages for an important administrative matter. You can check them by clicking the My Private Messages link above.