Hibernate version: 2.17

Name and version of the database you are using: MS SQL Server 2000

My question is regarding persistence. I have codes (Locations, Departments etc.) in our system. For the very first user who login in the system, I want to retrieve these codes and persist them; all subsequent users then should use the persistent codes instead of retrieving them again. How can I do this in Hibernate?

The issue becomes complicated when an administrator user login and define a new Location for example or delete a Location. In these cases, I want the persistent codes (of Location only) to be refreshed so that other users continue to work on the most current codes.

Any hint/algorithm is very appreciated.

Thanks

Take a look at the second-level-caching.