Hi,

I have a special need : ideally I'd like to have one webapp and a bunch of desktops clients, all accessing one database through Hibernate : desktops apps are only there for administration of the webapp.

I know there are cache problems - all theses apps should access only one shared cache.
Correct me if I'm wrong but second level cache occured at SessionFactory level, and only one SessionFactory per app and datasource is allowed, so it shouldn't work out of the box, right ?

But can someone tell me if it could be possible to have this kind of apps design, and if it is, how ?

Thanks.

The 2nd level cache is shared on a one-per-JVM basis by default, but you can configure that to be finer grained by using cache regions. Read section 19 of the ref docs.

The best and easiest way to share a single cache between multiple clients is for all the client to use a single webapp. Have user and admin logins to it. Don't have client-side applications.

It is possible to use your design, even with second level caches. You can use select-before-update, or just deal with the occasional stale object exception. And of course, you can turn off the second level cache.