error to update: Illegal attempt to associate a collection with two open sessions

[Rafael Ra]

Hello guys

I'm losing several nights with this problem
There are are many questions of same type, but none works for me.
someone could help me, please?

I have JSF Hibernate application

TeamModel

@Entity
@Table(name="team")
public class Team implements Serializable{
    
    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)
    @Column(name="id_team",nullable=false)
    private Integer idTeam;
    
    @Column(name="team",nullable=false)
    private String team;
    
    @OneToMany(fetch=FetchType.LAZY, targetEntity=Usuario.class,mappedBy="team")
    private Set usuarios = new HashSet(0);
    
    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="id_flm")
    private Flm flm;

---------------------

TeamDaoImpl

@Override
    public void atualizar(Team team) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            session.beginTransaction();
            session.update(team);
            session.beginTransaction().commit();
        } catch (Exception e){
            System.out.println("Erro ao inserir: "+e.getMessage());
            session.beginTransaction().rollback();
        } //finally {
            //session.close(); 
        //} 
   }

@Override
    public Team findById(Integer id_team) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        return (Team) session.load(Team.class, id_team);
    }

@Override
    public List<Team> findAll() {
        Session session = HibernateUtil.getSessionFactory().openSession();
        return session.createQuery("from Team ORDER BY id_flm ASC").list();
    }

---------------------

TeamBean

@ManagedBean(name="teamBean")
@ViewScoped
public class TeamBean implements Serializable {

---------------

FlmDaoImpl

public class FlmDaoImpl implements FlmDao {

@Override
    public List<Flm> selectItems() {
         List<Flm> listado = null;
        Session sesion = HibernateUtil.getSessionFactory().getCurrentSession();
        String sql = "FROM Flm";
        try {
            sesion.beginTransaction();
            listado =  sesion.createQuery(sql).list();
            sesion.beginTransaction().commit();
        } catch (Exception e) {
            sesion.beginTransaction().rollback();
            System.out.println("Erro no selecItemsFLM: "+e.getMessage());
        } 
        return listado;
    }

Note: merge() works only when update "team name" field, does not work to "flm" field

[Dave Tolls]

@Override
        try {
            session.beginTransaction();
            session.update(team);
            session.beginTransaction().commit();
   }

This code is opening two Transactions, and only committing the second one.
You should be retaining the reference to the original Transaction and calling commit on it.

As for the immediate problem, have you got the stack trace of the exception, and can you show where it is being thrown from?

[Rafael Ra]

Dave Tolls wrote:

@Override
        try {
            session.beginTransaction();
            session.update(team);
            session.beginTransaction().commit();
   }

This code is opening two Transactions, and only committing the second one.
You should be retaining the reference to the original Transaction and calling commit on it.

As for the immediate problem, have you got the stack trace of the exception, and can you show where it is being thrown from?

Updated, but it's still not working

public void update(Team team) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            session.beginTransaction(); //begin
            session.update(team);
            session.getTransaction().commit(); //get
        } catch (Exception e){
            System.out.println("Error update: "+e.getMessage());
            session.getTransaction().rollback(); //get
        }

I had debuged. It shows all the values passed in the debug, but throws exception in "error update" and finish with rollback :/

[Roel De Nijs]

Hi Rafael Ra,

First of all, a warm welcome to CodeRanch!

Rafael Ra wrote:It shows all the values passed in the debug, but throws exception in "error update" and finish with rollback :/

And what's the message (or even better stack trace) of this exception? Always TellTheDetails if you are encountering a problem. Maybe the exception itself tells you exactly what's wrong, maybe it doesn't. If you don't know how to do this, replace this line

System.out.println("Error update: "+e.getMessage());

with this one

e.printStackTrace();

And just copy/paste the output in a new post.

Kind regards,
Roel

[Rafael Ra]

Hello Roel

Sorry, I got it.

Thanks for your reply! Following the stracktrace:

Grave: org.hibernate.HibernateException: Illegal attempt to associate a collection with two open sessions
at org.hibernate.collection.AbstractPersistentCollection.setCurrentSession(AbstractPersistentCollection.java:410)
at org.hibernate.event.def.OnUpdateVisitor.processCollection(OnUpdateVisitor.java:43)
at org.hibernate.event.def.AbstractVisitor.processValue(AbstractVisitor.java:101)
at org.hibernate.event.def.AbstractVisitor.processValue(AbstractVisitor.java:61)
at org.hibernate.event.def.AbstractVisitor.processEntityPropertyValues(AbstractVisitor.java:55)
at org.hibernate.event.def.AbstractVisitor.process(AbstractVisitor.java:123)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performUpdate(DefaultSaveOrUpdateEventListener.java:293)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:223)
at org.hibernate.event.def.DefaultUpdateEventListener.performSaveOrUpdate(DefaultUpdateEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireUpdate(SessionImpl.java:564)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:552)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:544)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
at com.sun.proxy.$Proxy143.update(Unknown Source)
at com.changes.dao.impl.TeamDaoImpl.update(TeamDaoImpl.java:34)
at com.changes.bean.TeamBean.update(TeamBean.java:68)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at javax.el.BeanELResolver.invokeMethod(BeanELResolver.java:779)
at javax.el.BeanELResolver.invoke(BeanELResolver.java:528)
at javax.el.CompositeELResolver.invoke(CompositeELResolver.java:257)
at com.sun.el.parser.AstValue.invoke(AstValue.java:248)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:148)
at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:769)
at javax.faces.component.UICommand.broadcast(UICommand.java:300)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTas
Grave: k.java:54)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
at java.lang.Thread.run(Thread.java:745)

[Paul Clapham]

So: "Illegal attempt to associate a collection with two open sessions".

It's complaining about you having more than one open session, and trying to use the collection in both of them. I notice that your TeamDaoImpl calls openSession() in a couple of different places, so maybe that's where the two sessions are coming from?

[Dave Tolls]

In your FlmDaoImpl select method you are doing a commit().
It's a SELECT, there's nothing to commit.
In fact it's doing the same thing as the other code I mentioned, by opening a new transaction and committing that.

Anyway, as Paul says, you seem to be opening a lot of sessions.
In your FlmDaoImpl code shown you are at least retrieving the current session.

[Roel De Nijs]

Rafael Ra wrote:Thanks for your reply! Following the stracktrace:

And the stack trace meets my expectations. A clear error message indicates what's going wrong. It seems you have still multiple open sessions and try using a collection in both of them. So I agree with the advice of the others.

PS. That's why you should always TellTheDetails and provide as much information as possible (like a stack trace, a small code snippet, an unexpected output,...) in order to get helpful replies; otherwise it's really hard to pinpoint the actual issue and provide a (possible) solution.

[Rafael Ra]

Really... in my TeamDaoImpl there are two methods using opensession
is that the problem? Because one to show all data in my view and other to get data by ID team (prepare to update)

So I will post my complete TeamDaoImpl and a slice of my page team.jsf and TeamBean

public class TeamDaoImpl implements TeamDao {

    @Override
    public void inserir(Team team) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            session.beginTransaction();
            session.save(team);
            session.getTransaction().commit();
        } catch (Exception e){
            System.out.println("Erro ao inserir: "+e.getMessage());
            session.getTransaction().rollback();
        } 
    }
    

    @Override
    public void atualizar(Team team) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            session.beginTransaction();
            session.update(team);
            session.getTransaction().commit();
        } catch (Exception e){
            System.out.println("Erro ao atualizar: "+e.getMessage());
            e.printStackTrace();
            session.getTransaction().rollback();
        } //finally {
            //session.close(); 
        //} 
   }

    @Override
    public void excluir(Team team) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        try {
            session.beginTransaction();
            session.delete(team);
            session.getTransaction().commit();
        } catch (Exception e){
            System.out.println("Erro ao excluir: "+e.getMessage());
            session.getTransaction().rollback();
        } 
    }

    @Override
    public Team buscarPorId(Integer id_team) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        return (Team) session.load(Team.class, id_team);
    }

    @Override
    public List<Team> selectItems() {
        List<Team> listado = null;
        Session sesion = HibernateUtil.getSessionFactory().getCurrentSession();
        String sql = "FROM Team ORDER BY team ASC";
        try {
            sesion.beginTransaction();
            listado =  sesion.createQuery(sql).list();
            sesion.beginTransaction().commit();
        } catch (Exception e) {
            sesion.beginTransaction().rollback();
            System.out.println("Erro no selecItemsTEAM: "+e.getMessage());
        } 
        return listado;
        
    }

    @Override
    public List<Team> buscarTodos() {
        Session session = HibernateUtil.getSessionFactory().openSession();
        return session.createQuery("from Team ORDER BY id_flm ASC").list();
    }
    
}

TeamBean

public void prepararAtualizar(Integer id_team){ //prepararAtualizar = prepareToUpdate
        TeamDao teamDao = new TeamDaoImpl();
        team = teamDao.buscarPorId(id_team); //buscarPorId = findById
    }
    
    public void atualizar(){
        try {
            TeamDao teamDao = new TeamDaoImpl();
            teamDao.atualizar(team);
            FacesContext context = FacesContext.getCurrentInstance();            
            context.addMessage(null, new FacesMessage("Team successfully updated."));
            team = new Team();
        } catch (Exception e) {
            System.out.println("Erro ao ATUALIZAR: "+e.getMessage());
        }
    }

public List<Team> getTeams() {
        TeamDao teamDao = new TeamDaoImpl();
        teams = teamDao.buscarTodos(); //buscarTodos() = findAll()
        return teams;
    }

team.xhtml

<!-- Form: table teams -->
                            <h:form id="frmTeams">
                                <p:dataTable id="datatable" var="team" value="#{teamBean.teams}" emptyMessage="No teams found."
                                             paginator="true" rows="15" paginatorPosition="bottom" rowKey="#{team.idTeam}" selectionMode="single"
                                             paginatorTemplate="{CurrentPageReport}  {FirstPageLink} {PreviousPageLink} {PageLinks} {NextPageLink} {LastPageLink} {RowsPerPageDropdown}"  
                                             rowsPerPageTemplate="5,10,15,25,35">
                                    <f:facet name="header">  
                                        Search teams  
                                    </f:facet>

                                    <p:column headerText="Team" filterBy="#{team.team}" sortBy="#{team.team}">
                                        <h:outputText value="#{team.team}" />
                                    </p:column>
                                    
                                    <p:column headerText="FLM" filterBy="#{team.flm.name}" sortBy="#{team.flm.name}">
                                        <h:outputText value="#{team.flm.name}" />
                                    </p:column>
                                    
                                    <p:column style="width:11%; text-align: center" >  
                                        <sec:authorize ifAnyGranted="ROLE_ADMIN, ROLE_IPCDISP">
                                            <p:commandButton update=":frmEdit:pgEdit" actionListener="#{teamBean.prepararAtualizar(team.idTeam)}" 
                                                         oncomplete="dlgEdit.show()" image="icon-edit" title="Edit"/> 
                                            <p:commandButton update=":frmDelete" actionListener="#{teamBean.prepararAtualizar(team.idTeam)}" oncomplete="dlgDelete.show()" image="icon-delete" title="Delete"/>
                                        </sec:authorize>               
                                    </p:column>
                                   
                                </p:dataTable>                 
                                   
                            </h:form>


 <!-- Form: edit team -->
                           <h:form id="frmEdit">
                                <p:dialog header="Edit" widgetVar="dlgEdit" resizable="false" id="dlgEdit"  modal="true"> 
                                    <p:growl id="growlEdit" showDetail="true" sticky="true"/>
                                    <h:panelGrid id="pgEdit" columns="2" cellpadding="4" style="margin:0 auto;">                                         
                                         <h:outputText value="Team name: *" /> 
                                        <p:inputText value="#{teamBean.team.team}" required="true" style="width: 200px"/>
                                       
                                        <h:outputText value="FLM: *" /> 
                                        <p:selectOneMenu id="lblteam" value="#{teamBean.team.flm.idFlm}" style="width:150px;" required="true" requiredMessage="Valor é obrigatório">             
                                            <f:selectItems  value="#{flmBean.selectOneItemsFlm}"/>
                                        </p:selectOneMenu>                                   
                                    </h:panelGrid> 
                                        
                                    <p:separator/>
                                    <p:commandButton value=" Edit" update=":frmTeams:datatable, growlEdit, dlgEdit" 
                                                     actionListener="#{teamBean.atualizar()}" oncomplete="dlgEdit.hide()" image="icon-save"/>
                                    <p:commandButton value=" Cancel" update=":frmTeams:datatable" oncomplete="dlgEdit.hide()" image="icon-cancel"/> 
                                </p:dialog>  
                            </h:form> 

[Paul Clapham]

Rafael Ra wrote:Really... in my TeamDaoImpl there are two methods using opensession
is that the problem? Because one to show all data in my view and other to get data by ID team (prepare to update)

Is that the problem? Read the error message again, it's extremely clear that it doesn't like it when you put a collection into two sessions. That's different from having two methods using openSession(). In general when you read error messages don't try to apply interpetations like that to them. Start from what the message actually says and work your way back from there.

Anyway I don't see why you need two sessions, probably because your requirements aren't clear to me. From what you said it looks like you need two different collections, so putting them into two different sessions would be okay (but still unnecessary). But the error message says you only have one collection being put into two different sessions. So there's something in your code which is working wrong. Perhaps it's putting a collection in the wrong session. Perhaps it's only creating one collection instead of two. But those are just guesses I'm making because I'm not going to spend a lot of time going through all of your code. That's for you to do now that the error message has been explained.

[Rafael Ra]

I'm not a programmer.. I'm doing this program by hobby and I don't want to forget waht I learned in college a few years ago
I work with infrastructure
and then some concepts I still can't understand like a collection

I see a problem, but that's ok

Thanks everybody that helped!!

[Rafael Ra]

Resolved last week. It's fine!

Thanks!

Changed my HibernateUtil and DAO classes.
All methods must be using session.close and getsession, not opensession

Following DAO example:

@Override
    public Team buscarPorId(Integer id_team) {
        Team retorno = new Team();
        try {
            session = HibernateUtil.getSession();
            session.beginTransaction();
            retorno = (Team) session.get(Team.class, id_team);
            session.getTransaction().commit();
        } catch (Exception e) {
            session.getTransaction().rollback();
            e.printStackTrace();
        } finally {
            session.close();
        }
        return retorno;
    }

public List<Team> buscarTodos() {
        List<Team> listTeamsBuscarTodos = null;
        try {
            session = HibernateUtil.getSession();
            listTeamsBuscarTodos = session.createQuery("from Team ORDER BY id_flm, team ASC").list();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            session.close();
        }
        return listTeamsBuscarTodos;
    }

HibernateUtil

public class HibernateUtil {

	public static void main(String[] args) {
		System.out.println("Inicio");

		Configuration cfg = new Configuration();
		cfg.configure();
		SchemaExport se = new SchemaExport(cfg);
		se.create(true, true);

		System.out.println("Fim");
	}

	private static SessionFactory sessionFactory = null;
	private static ServiceRegistry serviceRegistry;

	static {
		try {
			sessionFactory = getSessionFactory();
		} catch (Throwable ex) {
			System.err.println("Initial SessionFactory creation failed." + ex);
			throw new ExceptionInInitializerError(ex);
		}
	}

	public static SessionFactory getSessionFactory() {
		if (sessionFactory == null) {
			Configuration configuration = new Configuration();
			configuration.configure();
                        configuration.addAnnotatedClass(Customer.class);
                        configuration.addAnnotatedClass(Team.class);
                        configuration.addAnnotatedClass(Usuario.class);
			serviceRegistry = new ServiceRegistryBuilder().applySettings(
					configuration.getProperties()).buildServiceRegistry();
			sessionFactory = configuration.buildSessionFactory(serviceRegistry);
			sessionFactory.openSession();
			return sessionFactory;
		}
		return sessionFactory;
	}

	public static Session getSession() {
		return sessionFactory.openSession();
	}

	/*
	 * 
	 * public static SessionFactory getSessionFactory() { if (sessionFactory ==
	 * null) { try { sessionFactory = new AnnotationConfiguration().configure()
	 * .buildSessionFactory(); } catch (Exception e) { e.printStackTrace(); } }
	 * return sessionFactory; }
	 */
}

[Paul Clapham]

Good work, Rafael!

[Roel De Nijs]

Rafael Ra wrote:Resolved last week. It's fine!

Thanks!

Changed my HibernateUtil and DAO classes.
All methods must be using session.close and getsession, not opensession

Glad to hear you were able to fix your issue!

Thanks for coming back and sharing your solution. This will probably be very helpful for other ranchers as well. Have a cow!

Kind regards,
Roel