The second level cache is enabled on the application.
The Query Cache is enabled on the application.

There is a table TABLE_ACCOUNTS and queries Q1 Q2 and Q3 on the same table.

The above queries will return a set of Data, these queries are frequently used in the application by many concurrent threaded. I was planning to use QueryCache to cache the result of the Query.

But the twist in the story is my TABLE_ACCOUNTS table is updated frequently also. The updates will NOT effect the result of Q1 and Q2. But I see in hibernate that, the moment table on which the query was applied is updated the result of Q1 and Q2 are removed from the cache.

I want to know a mechanism where in I still keep my Query Result in the cache even though the table got updated.

TIA,
Naseer