Hello,

I am working on a web based Struts application with MySQL hosted on Tomcat. I use Hibernate 3.1 for my ORM and I seem to have run into a problem.

During an operation I retrieve an object from the database and within the same operation I have to retrieve the same object again from the database. The first retrieval works fine without any issues, but the second retrieval cant seem to find the data.

I'm still a newbie when it comes to Hibernate session handling and I was wondering if any of you could tell me what I am doing wrong!

Thanks
G

From API documentation:

Thanks for the reply.

My problem is this, when a user comes in he needs to submit his order. The system is supposed to accept the order and then adjust the other elements in its database. For this it tries to load up certain entities twice within the same session.

It succeeds in retrieving the object the first time, but the second time it fails to retrieve the object! What am I doing wrong please?

Thanks

Kind of hard to answer that since you don't tell us what you are doing. How do you retrieve the object? Are you, for example, using Session.get(), Session.load(), a HQL query, a critera query, etc? What kind of failure do you get? Exceptions? Any log/debug output?

In any case, a single Session can only hold one reference to the same entity. Use Session.refresh() to re-read the info from the database into the same entity or Session.evict() to detach the first object from the session before you are trying to load it a second time.