Hi all,

I need to use lazy initialization into Spring framework.

I have a parent-children relationship.

when in my class I do

...
Events evento = new Events();
evento.setTitle("test");

Account account = new Account();
account.addEvent(evento);
accountManager.saveAccount(account);
...

I receive an
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: it.urlandus.events.app.domain.Account.events, no session or session was closed

at the account.addEvent(evento); row.

so I've add an OpenSessionInViewInterceptor to prevent this:

<bean name="openSessionInViewInterceptor" class="org.springframework.orm.hibernate3.support.OpenSessionInViewInterceptor">
<property name="sessionFactory"><ref bean="sessionFactory"/></property>
</bean>

but now nothing happens! I don't have excpetions but the insert of event don't work.

Many thanks,
Marco

Hibernate version: 3.2.5ga

Mapping documents:

@Entity
@Table(name="ev_accounts")
public class Account implements Serializable {

/* Private Fields */
@Id @GeneratedValue(strategy=GenerationType.IDENTITY)
private int id;
...
@org.hibernate.annotations.CollectionOfElements()
@JoinTable(name="ev_authorities",joinColumns= @JoinColumn(name="account_id"))
@Column(name= "authority",nullable=false)
private Set<String> authorities = new HashSet<String>();

@OneToMany(mappedBy="account")
@Cascade({org.hibernate.annotations.CascadeType.SAVE_UPDATE,org.hibernate.annotations.CascadeType.DELETE})
private Set<Event> events = new HashSet<Event>();
...

public void addEvent(Event event){
event.setAccount(this);
events.add(event);
}
...
}


@Entity
@Table(name="ev_events")
public class Event implements Serializable {

@Id @GeneratedValue(strategy=GenerationType.IDENTITY)
private int id;
...
@Embedded
private EventLocation eventLocation;

@ManyToOne(targetEntity=it.urlandus.events.app.domain.Account.class)
@JoinColumn(name="account_id",nullable=false)
private Account account;
...
}



Code between sessionFactory.openSession() and session.close():

I use Spring wiht a GenericHibernateDao based on HibernateDaoSupport in order to manage objects

Name and version of the database you are using: mySql 5


Debug level Hibernate log excerpt:

In my log I see only:

[org.hibernate.loader.Loader] - loading collection: [it.urlandus.events.app.domain.Account.events#1]
2008-01-31 18:29:01,252 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2008-01-31 18:29:01,253 DEBUG [org.hibernate.SQL] -
select
events0_.account_id as account11_1_,
events0_.id as id1_,
events0_.id as id1_0_,
events0_.account_id as account11_1_0_,
events0_.basePrice as basePrice1_0_,
events0_.email as email1_0_,
events0_.endDate as endDate1_0_,
events0_.city as city1_0_,
events0_.country as country1_0_,
events0_.location as location1_0_,
events0_.province as province1_0_,
events0_.startDate as startDate1_0_,
events0_.title as title1_0_
from
ev_events events0_
where
events0_.account_id=?
2008-01-31 18:29:01,284 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open ResultSet (open ResultSets: 0, globally: 0)
2008-01-31 18:29:01,284 DEBUG [org.hibernate.loader.Loader] - result set contains (possibly empty) collection: [it.urlandus.events.app.domain.Account.events#1]
2008-01-31 18:29:01,289 DEBUG [org.hibernate.loader.Loader] - result row: EntityKey[it.urlandus.events.app.domain.Event#11]
2008-01-31 18:29:01,334 DEBUG [org.hibernate.loader.Loader] - found row of collection: [it.urlandus.events.app.domain.Account.events#1]
2008-01-31 18:29:01,336 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close ResultSet (open ResultSets: 1, globally: 1)
2008-01-31 18:29:01,336 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2008-01-31 18:29:01,336 DEBUG [org.hibernate.engine.TwoPhaseLoad] - resolving associations for [it.urlandus.events.app.domain.Event#11]
2008-01-31 18:29:01,337 DEBUG [org.hibernate.engine.TwoPhaseLoad] - done materializing entity [it.urlandus.events.app.domain.Event#11]
2008-01-31 18:29:01,338 DEBUG [org.hibernate.engine.loading.CollectionLoadContext] - 1 collections were found in result set for role: it.urlandus.events.app.domain.Account.events
2008-01-31 18:29:01,338 DEBUG [org.hibernate.engine.loading.CollectionLoadContext] - collection fully initialized: [it.urlandus.events.app.domain.Account.events#1]
2008-01-31 18:29:01,338 DEBUG [org.hibernate.engine.loading.CollectionLoadContext] - 1 collections initialized for role: it.urlandus.events.app.domain.Account.events
2008-01-31 18:29:01,338 DEBUG [org.hibernate.engine.StatefulPersistenceContext] - initializing non-lazy collections
2008-01-31 18:29:01,338 DEBUG [org.hibernate.loader.Loader] - done loading collection
2008-01-31 18:29:01,339 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1ef577d] for key [org.hibernate.impl.SessionFactoryImpl@6e056e] bound to thread [http-8080-Processor24]
2008-01-31 18:29:01,339 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1ef577d] for key [org.hibernate.impl.SessionFactoryImpl@6e056e] bound to thread [http-8080-Processor24]
2008-01-31 18:29:01,339 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] - Found thread-bound Session for HibernateTemplate
2008-01-31 18:29:01,342 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] - Not closing pre-bound Hibernate Session after HibernateTemplate

dude make sure that this should flow like this

msj4u, he shouldn't need to wrap his code with your suggested code when he's using Open Session In View.

icdevelop, I can't see anything wrong with what you have got. Try turning on debug or trace on org.springframework.orm.hibernate3.support.OpenSessionInViewInterceptor as it may be able to offer you a reason.

As personal preference, I use OpenSessionInViewFilter. If your app is a web-based product then you could try configuring that bean instead?

Hi,

I've tried also to use the OpenSessionInViewFilter but the result is the same.

In my log in this case I see:

2008-02-01 14:00:37,601 DEBUG [org.springframework.orm.hibernate3.support.OpenSessionInViewFilter] - Using SessionFactory 'sessionFactory' for OpenSessionInViewFilter
2008-02-01 14:00:37,601 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'sessionFactory'
2008-02-01 14:00:37,601 DEBUG [org.springframework.orm.hibernate3.support.OpenSessionInViewFilter] - Opening single Hibernate Session in OpenSessionInViewFilter
2008-02-01 14:00:37,601 DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] - Opening Hibernate Session
2008-02-01 14:00:37,601 DEBUG [org.hibernate.impl.SessionImpl] - opened session at timestamp: 12018708376
2008-02-01 14:00:37,601 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Bound value [org.springframework.orm.hibernate3.SessionHolder@7835ec] for key [org.hibernate.impl.SessionFactoryImpl@1871f70] to thread [http-8080-Processor24]
2008-02-01 14:00:37,601 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'httpSessionContextIntegrationFilter'
2008-02-01 14:00:37,601 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'logoutFilter'
2008-02-01 14:00:37,601 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'authenticationProcessingFilter'
2008-02-01 14:00:37,602 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'securityContextHolderAwareRequestFilter'
2008-02-01 14:00:37,602 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'anonymousProcessingFilter'
2008-02-01 14:00:37,602 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'exceptionTranslationFilter'
2008-02-01 14:00:37,602 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'filterInvocationInterceptor'
2008-02-01 14:00:37,602 DEBUG [org.springframework.web.context.support.XmlWebApplicationContext] - Publishing event in context [org.springframework.web.context.support.XmlWebApplicationContext@843edc]: org.acegisecurity.event.authorization.AuthorizedEvent[source=FilterInvocation: URL: /page/secure/form/newStep1.htm?ts=1201870837594]
2008-02-01 14:00:37,602 DEBUG [org.springframework.web.servlet.DispatcherServlet] - DispatcherServlet with name 'events' received request for [/events/page/secure/form/newStep1.htm]
2008-02-01 14:00:37,603 DEBUG [org.springframework.web.servlet.DispatcherServlet] - Bound request context to thread: org.acegisecurity.wrapper.SavedRequestAwareWrapper@1c38fe
2008-02-01 14:00:37,603 DEBUG [org.springframework.web.servlet.DispatcherServlet] - Testing handler map [org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping@ed01c3] in DispatcherServlet with name 'events'
2008-02-01 14:00:37,603 DEBUG [org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping] - Looking up handler for [/page/secure/form/newStep1.htm]
2008-02-01 14:00:37,603 DEBUG [org.springframework.web.servlet.DispatcherServlet] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter@eaab5]
2008-02-01 14:00:37,603 DEBUG [org.springframework.web.servlet.DispatcherServlet] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter@e95c63]
2008-02-01 14:00:37,603 DEBUG [it.urlandus.events.app.web.controller.form.EventNewStepOne] - Creating new command of class [it.urlandus.events.app.domain.Event]
2008-02-01 14:00:37,611 DEBUG [org.springframework.validation.ValidationUtils] - Invoking validator [it.urlandus.events.app.web.controller.form.validator.EventNewStepOneValidator@e1cfa7]
2008-02-01 14:00:37,611 INFO [it.urlandus.events.app.web.controller.form.validator.EventNewStepOneValidator] - Validating : ttt
2008-02-01 14:00:37,613 DEBUG [org.springframework.validation.ValidationUtils] - Validator found no errors
2008-02-01 14:00:37,613 DEBUG [it.urlandus.events.app.web.controller.form.EventNewStepOne] - No errors -> processing submit
2008-02-01 14:00:37,617 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7835ec] for key [org.hibernate.impl.SessionFactoryImpl@1871f70] bound to thread [http-8080-Processor24]
2008-02-01 14:00:37,618 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7835ec] for key [org.hibernate.impl.SessionFactoryImpl@1871f70] bound to thread [http-8080-Processor24]
2008-02-01 14:00:37,618 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] - Found thread-bound Session for HibernateTemplate
2008-02-01 14:00:37,655 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7835ec] for key [org.hibernate.impl.SessionFactoryImpl@1871f70] bound to thread [http-8080-Processor24]
2008-02-01 14:00:37,669 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2008-02-01 14:00:37,669 DEBUG [org.hibernate.jdbc.ConnectionManager] - opening JDBC connection
2008-02-01 14:00:37,672 DEBUG [org.hibernate.SQL] -
select
this_.id as id0_0_,
this_.email as email0_0_,
this_.enabled as enabled0_0_,
this_.firstname as firstname0_0_,
this_.lastname as lastname0_0_,
this_.password as password0_0_,
this_.url as url0_0_,
this_.username as username0_0_
from
ev_accounts this_
where
1=1
and this_.username=?
2008-02-01 14:00:37,687 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open ResultSet (open ResultSets: 0, globally: 0)
2008-02-01 14:00:37,690 DEBUG [org.hibernate.loader.Loader] - result row: EntityKey[it.urlandus.events.app.domain.Account#1]
2008-02-01 14:00:37,700 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close ResultSet (open ResultSets: 1, globally: 1)
2008-02-01 14:00:37,700 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2008-02-01 14:00:37,702 DEBUG [org.hibernate.engine.TwoPhaseLoad] - resolving associations for [it.urlandus.events.app.domain.Account#1]
2008-02-01 14:00:37,717 DEBUG [org.hibernate.engine.TwoPhaseLoad] - done materializing entity [it.urlandus.events.app.domain.Account#1]
2008-02-01 14:00:37,717 DEBUG [org.hibernate.engine.StatefulPersistenceContext] - initializing non-lazy collections
2008-02-01 14:00:37,717 DEBUG [org.hibernate.jdbc.ConnectionManager] - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
2008-02-01 14:00:37,718 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] - Not closing pre-bound Hibernate Session after HibernateTemplate
2008-02-01 14:00:37,718 DEBUG [it.urlandus.events.app.web.controller.form.EventNewStepOne] - PASSO 1
2008-02-01 14:00:37,719 DEBUG [org.hibernate.loader.Loader] - loading collection: [it.urlandus.events.app.domain.Account.events#1]
2008-02-01 14:00:37,719 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2008-02-01 14:00:37,719 DEBUG [org.hibernate.SQL] -
select
events0_.account_id as account11_1_,
events0_.id as id1_,
events0_.id as id1_0_,
events0_.account_id as account11_1_0_,
events0_.basePrice as basePrice1_0_,
events0_.email as email1_0_,
events0_.endDate as endDate1_0_,
events0_.city as city1_0_,
events0_.country as country1_0_,
events0_.location as location1_0_,
events0_.province as province1_0_,
events0_.startDate as startDate1_0_,
events0_.title as title1_0_
from
ev_events events0_
where
events0_.account_id=?
2008-02-01 14:00:37,723 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open ResultSet (open ResultSets: 0, globally: 0)
2008-02-01 14:00:37,723 DEBUG [org.hibernate.loader.Loader] - result set contains (possibly empty) collection: [it.urlandus.events.app.domain.Account.events#1]
2008-02-01 14:00:37,728 DEBUG [org.hibernate.loader.Loader] - result row: EntityKey[it.urlandus.events.app.domain.Event#11]
2008-02-01 14:00:37,728 DEBUG [org.hibernate.loader.Loader] - found row of collection: [it.urlandus.events.app.domain.Account.events#1]
2008-02-01 14:00:37,730 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close ResultSet (open ResultSets: 1, globally: 1)
2008-02-01 14:00:37,731 DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2008-02-01 14:00:37,731 DEBUG [org.hibernate.engine.TwoPhaseLoad] - resolving associations for [it.urlandus.events.app.domain.Event#11]
2008-02-01 14:00:37,731 DEBUG [org.hibernate.engine.TwoPhaseLoad] - done materializing entity [it.urlandus.events.app.domain.Event#11]
2008-02-01 14:00:37,731 DEBUG [org.hibernate.engine.loading.CollectionLoadContext] - 1 collections were found in result set for role: it.urlandus.events.app.domain.Account.events
2008-02-01 14:00:37,732 DEBUG [org.hibernate.engine.loading.CollectionLoadContext] - collection fully initialized: [it.urlandus.events.app.domain.Account.events#1]
2008-02-01 14:00:37,732 DEBUG [org.hibernate.engine.loading.CollectionLoadContext] - 1 collections initialized for role: it.urlandus.events.app.domain.Account.events
2008-02-01 14:00:37,732 DEBUG [org.hibernate.engine.StatefulPersistenceContext] - initializing non-lazy collections
2008-02-01 14:00:37,732 DEBUG [org.hibernate.loader.Loader] - done loading collection
2008-02-01 14:00:37,732 DEBUG [it.urlandus.events.app.web.controller.form.EventNewStepOne] - PASSO 2
2008-02-01 14:00:37,732 DEBUG [it.urlandus.events.app.domain.logic.AccountManagerImpl] - Prima
2008-02-01 14:00:37,733 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7835ec] for key [org.hibernate.impl.SessionFactoryImpl@1871f70] bound to thread [http-8080-Processor24]
2008-02-01 14:00:37,733 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@7835ec] for key [org.hibernate.impl.SessionFactoryImpl@1871f70] bound to thread [http-8080-Processor24]
2008-02-01 14:00:37,733 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] - Found thread-bound Session for HibernateTemplate
2008-02-01 14:00:37,736 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] - Not closing pre-bound Hibernate Session after HibernateTemplate
2008-02-01 14:00:37,736 DEBUG [it.urlandus.events.app.domain.logic.AccountManagerImpl] - dopo
2008-02-01 14:00:37,736 DEBUG [it.urlandus.events.app.web.controller.form.EventNewStepOne] - PASSO 3
2008-02-01 14:00:37,736 DEBUG [it.urlandus.events.app.web.interceptor.TabInterceptor] - VIEW!! :/events/page/secure/form/newStep1.htm
2008-02-01 14:00:37,736 DEBUG [it.urlandus.events.app.web.interceptor.TabInterceptor] - Area: form
2008-02-01 14:00:37,736 INFO [org.springmodules.xt.ajax.AjaxInterceptor] - Post-handling ajax request for event: validate
2008-02-01 14:00:37,736 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Returning cached instance of singleton bean 'ajaxValidationHandler'
2008-02-01 14:00:37,739 DEBUG [org.springmodules.xt.ajax.AbstractAjaxHandler] - Event supported by method: public org.springmodules.xt.ajax.AjaxResponse org.springmodules.xt.ajax.validation.DefaultValidationHandler.validate(org.springmodules.xt.ajax.AjaxSubmitEvent)
2008-02-01 14:00:37,740 INFO [org.springmodules.xt.ajax.AbstractAjaxHandler] - Invoking method: public org.springmodules.xt.ajax.AjaxResponse org.springmodules.xt.ajax.validation.DefaultValidationHandler.validate(org.springmodules.xt.ajax.AjaxSubmitEvent)
2008-02-01 14:00:37,744 DEBUG [org.springmodules.xt.ajax.util.AjaxResponseSender] - Sending ajax response: <?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/css" href=""?>
<ajax-response xml:space="preserve">
<redirect><content><target url="/events/page/secure/main.htm?org.springframework.validation.BindingResult.newFormOne=org.springframework.validation.BeanPropertyBindingResult%3A+0+errors&amp;newFormOne=it.urlandus.events.app.domain.Event%40b8445e97"/></content></redirect>
</ajax-response>
2008-02-01 14:00:37,744 DEBUG [org.springframework.web.servlet.DispatcherServlet] - Null ModelAndView returned to DispatcherServlet with name 'events': assuming HandlerAdapter completed request handling
2008-02-01 14:00:37,744 DEBUG [org.springframework.web.servlet.DispatcherServlet] - Cleared thread-bound request context: org.acegisecurity.wrapper.SavedRequestAwareWrapper@1c38fe
2008-02-01 14:00:37,744 DEBUG [org.springframework.web.servlet.DispatcherServlet] - Successfully completed request
2008-02-01 14:00:37,744 DEBUG [org.springframework.web.context.support.XmlWebApplicationContext] - Publishing event in context [org.springframework.web.context.support.XmlWebApplicationContext@8a93d9]: ServletRequestHandledEvent: url=[/events/page/secure/form/newStep1.htm]; client=[127.0.0.1]; method=[POST]; servlet=[events]; session=[DD7BFEF8C20CACB0B0BF8770BF79EE9E]; user=[marco]; time=[142ms]; status=[OK]
2008-02-01 14:00:37,745 DEBUG [org.springframework.web.context.support.XmlWebApplicationContext] - Publishing event in context [org.springframework.web.context.support.XmlWebApplicationContext@843edc]: ServletRequestHandledEvent: url=[/events/page/secure/form/newStep1.htm]; client=[127.0.0.1]; method=[POST]; servlet=[events]; session=[DD7BFEF8C20CACB0B0BF8770BF79EE9E]; user=[marco]; time=[142ms]; status=[OK]
2008-02-01 14:00:37,745 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] - Removed value [org.springframework.orm.hibernate3.SessionHolder@7835ec] for key [org.hibernate.impl.SessionFactoryImpl@1871f70] from thread [http-8080-Processor24]
2008-02-01 14:00:37,745 DEBUG [org.springframework.orm.hibernate3.support.OpenSessionInViewFilter] - Closing single Hibernate Session in OpenSessionInViewFilter
2008-02-01 14:00:37,745 DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] - Closing Hibernate Session

Many thanks
Marco