the session cache is making mistakes

d2clon · **Joined:** Fri Oct 07, 2005 11:53 am **Posts:** 9

Hibernate version: 3
Name and version of the database you are using: Mysql 5.0

I'm not using any type of cache.

I update an object and on the database the update is ok but hibernate load it with the last status before the changed.

If I try to re-load the object again the object is loaded with the correct status, If I try again to re-load maybe it will be loaded with the correct status or not.. ?¿¡

I thing the problem is here:

Code:

DEBUG org.hibernate.event.def.DefaultLoadEventListener(244) - entity found in session cache

This way is how I open and close the Hibernate sessions:

Code:

Session s = SessionFactory.openSession();
session.beginTransaction();

... the update ...

session.getTransaction().commit();

I don't use ehcache.. not lazy loads..

What is happening?

Thanks.
d2clon

d2clon · **Joined:** Fri Oct 07, 2005 11:53 am **Posts:** 9

I solved the problem adding a session.close() to the sequence

Code:

Session s = SessionFactory.openSession();
session.beginTransaction();

... the update ...

session.getTransaction().commit();
session.close();

rahul dongre · **Posted:** Mon Jun 04, 2007 5:28 pm

great !!

Thumb rule, always close session if your are opening.