Hello,

With this I update my help request. Based on the demo application
CaveaTemptor I build a web application with Tomcat, Mysql, Hibernate 3 and Common Controls. Within one browser session everything from update, select and delete works without any problems.

If I have second or third browser session the updates of data in one session is not propagated to the other browser session. The session are not invalidated by Hibernate and loads the data from the session cache and not from the database. Against this behaviour new data stored by save is visible for other browser session. If I clear the session before loading the data of other browser session are visible. But I don't like to use clear() because I will use lazy loading.

What can I do? I search for solution for more then two weeks and have also placed some posting in this forum, but without any concret solutions.

Is this really my own problem. I think the update the session cache of other browser sessions should be done by Hibernate. Does Hibernate do this?

Thanks
Thomas

No, Hibernate doesn't do that. Either you want cached (and thus potentially stale) data, or you want non-stale (and there's probably not cached) data. The database does not push information out along Hibernate's JDBC connections, and Hibernate Sessions do no tell each other what they are doing (how can they, seeing as different sessions can easily be on different machines, possibly even on different networks, just connected to the same database).

If you have any requirements like this, you have to solve the problems independently of Hibernate. Application servers are good platforms for solving this sort of problem: if you're using anything more light-weight, then you're probably letting yourself in for a lot of work.