I'm wondering if there's a way to use the query cache such that even if updates/inserts/deletes happen to the underlying tables of the query that it not invalidate the cached query results and instead allow them to still be fetched and not hit the DB. Instead it would depend on some kind of other cache entry expiration policy, such as a TTL.

The specific use case is that we have queries where it's OK if the results are stale and we'd like to minimize DB access even more for these cached queries.

Hibernate version:

3.2.0.ga

Hi chumpboy,

I am not sure about these cache.But for your requirment you could use TIBCO EMS which can be integrated with Oracle (using Trigger).For any update Insert you could send the updated value to client.This Solution is not pretty much align to your requirment could be possible one solution