I have a pretty complex SQL query that returns results from a few different tables and performs a UNION etc. I execute this query using straight JDBC using session.connection().

I would like to be able to cache my results though. I know there is an Update Timestamp cache that Hibernate uses that has the timestamp of the latest change to any underlying table. Is there an API call somewhere that I can pass in a list of tables or POs I would like to check and a timestamp, where a boolean would come back indicating if the table has been modified since that time? This is the only way I would trust my cached results.

Thanks in advance,
Daniel

No there is no way to interfere with Hibernate cache from the outside.

Thanks for your reply.

Perhaps I was not clear though. I am not "interfering" with the Hibernate cache in any way. I will use my own caching system to actually cache my result set. All I need to know is if there is a way to ask Hibernate if a list of tables are up to date from a specific time. The Hibernate query cache already uses such functionality, is there a way to expose that very function in an API. Or is this something that can perhaps be added? I am sure it could be useful in other situations as well.

Daniel