I am having a horrible time with hibernate updating the database of an existing record. I am using struts, and have an action form and a value object. When I first open a record from the database, I create my value object. Here is my code in my DAO for getting the record.

I then create my action form for struts from this value object, let the user update the information, and then when they hit save, I update the value object. I then try to save the value object using this code.

It throws the Exception org.hibernate.HibernateException: illegally attempted to associate a proxy with two open Sessions
on the first update of the line. I understand that I created a session when I queried the objects. All I want to do is update them. How do I clear out the old session, or re-use it, or what do I need to do here?

If I close the session after the query, I get a lazyloading exception that a session doesn't exist. If I try to clear the session before updating the classes, it has no effect. Can someone tell me what I am missing? Thanks.

bumping this up.... somebody should know this... Please help

I made some changes which made this work.

When I did my original query, I needed to close the Hibernate session. I tried that before and was getting an error, however, because lazyloading was on, and many of the attributes were accessed AFTER the DAO ran, (namely when I was copying from the value object to the action form). I could not turn off lazy loading even when I set lazy loading to false. So what I did is created the Hybernate Session in my Action Class, passed it to my service, which then passed it to the DAO. Then when my action class got the value object back, it could copy the object to the action form and THEN close the session.

Evidently in my next trip to the server, HibernateUtil.getSession() got a different session, and not the session that was created on my query. Because the session in the query was still "floating around", when I created a new one, and tried to update the object it caused a problem. This brings me to another question.

How do you reference an existing Hibernate Session that may still be active from a past trip to the server, or do you have to explicitely store the hibernate session in an http session, or in a scope available to the user in each trip.

Also, Isn't HibernateUtil a singleton which should pass you the one Hybernate session active for your user thread in the application?

Thanks in advance for any good feed back.