Hello there! I'd like to cache some collections using a read-write approach. Is it possible to invalidate the cache region for those collections every time a new object is inserted/deleted/updated? I was thinking in using a kind of Interceptor for this. Is this possible? How can i do this?

Regards

Adding another question to the cache questions :)

I have a Profile which has a Set of functions

Function is defined as a read-only in cache (since it will never change)

the set is defined as read-write, as the collection might be changed (new functions may be add/removed).

Well problem is hibernate is hitting the database n-times where n is the number of functions:

SELECT * FROM Functions where PROFILE_ID = ?

SELECT * FROM Functions where FUNC_ID = ? (loops thorough the result of the first query)

With no cache, this does not happen. What am I missing