I'm here struggling with quite a cache problem. Why hibernate does not return the changes that already propagated to mySql database. I am running resin pro as app server.
I created 69 "product" objects and persisted to MySql.
After getting all of them to a browser page and update some properties of some (say 5) product objects and session.update then session.flush then commit to db. MySql shows correct data for all 69 products but when I reload/ re get the list of 69 products, some of the 5 rows I modified show latest data, some show old data. And the more confusing things are sometimes the list show new/correct data, sometime old data.
Closing and restarting browser (IE and NS) does not help, restart resin (app server) always results in correct data. Any one has similar problems?
Thanks alot in advance.

Hibernate version: 3.0

Mapping documents:

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


Full stack trace of any exception that occurs:

Name and version of the database you are using:MySql 5.0

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

That looks like a symptom of accidentally using long sessions. Are you creating a new hiberante session for every web request? And are you closing the hibernate session at the end of the request? You have to either do that, or (if you're deliberately using long sessions) set a short expiry time on your cache. Check your cache's documentation for info on how to do that.