Hi,

I'm caching native sql queries with L2 cache. Everything works fine. I'm getting cache hits, etc. There's a flaw though (probably I missed something). Everytime before I execute query I need to call db procedure which is time consuming and I'd like to avoid if possible.
The scenario is as follows: if I get cache miss I need to call db procedure and then let hibernate proceed with actual query against db; but if I get cache hit I don't want db procedure being executed. Is there a way to register some listener which would be notified when cache hit/miss took place?

I'm using hibernate 3.2.4, ehchache 1.5.0.

Solved :)

I created decorated cache with methods for adding and removing listeners. Then I replaced original cache with decorated one in CacheManager. Listeners' notification methods are triggered upon cache miss/hit in decorated cache.

Solution found (as usual) in TFM ;)