Hi,
I'm using per-thread hibernate session (ThreadLocal) but additionally i'm saving the session to http-session so what i am actually getting is a per-http-session hibernate session.

I've the hibernate session's flush mode set to FlushMode.COMMIT so every time i perform any operation it is immediately updated to the database (after the transaction commit). I can see the updated records, so the flushing is working.

In spite of this, when i query records from another session i get them out of date. It seems like the session does not get rid of the changes made by another session so it gets the records from cache.

Do anybody know what is happening? How can i synchronize my sessions?
Any help will be welcome,
Thanks

Session has a cache, so changes made in a session are not known by the others (That's the normal working way, and I don't know anyway to share info between sessions). The only way to refresh data, so that it is read again from the database, is using the refresh() function of the session, but you may only refresh a single object each time.

session.refresh(myBean)

Where myBean is an entity you saved or read from the database, and is still in session.

Another option, would be to delete the whole session cache, using clear(), or a single entity using evict

Anyway, Is there any reason why you are using a per-http-session hibernate session?. If you wish to cache your data in a consistent way to avoid unnecesary database access, it is much better to use a second level cache, and an hibernate session per http request. That way, you will have an small cache per each request (hibernate session cache), and a bigger cache, common to all users.

Thanks for your reply.

In fact i would like to keep a single hibernate session for all the requests if that's possible without collision between the requests.

But maybe the way you describe is better, i don't know anything about second level cache, can you give me some help on implementing it?

Thanks

I never used one, but chapter 19.2 of the documentation tells you how to use it (seems not difficult).

http://www.hibernate.org/hib_docs/v3/reference/en-US/html_single/#performance-cache

You don't have to implement a second level cache, just download and use one of the supported ones. For example EHCache:

http://ehcache.sourceforge.net/

Ok, thanks for the links.

I will read and try to solve it in the simplest way i find, cause i am new with hibernate and there are still many aspects i don't know.

I will let you know when i find a solution and how i did it.
Thanks.