Hi all,

Is there a way (programmatically) to tell if the query results are from second level cache instead of database? (of course, without looking at log)?

thanks,

Hung-

Just a guess here:
By enabling the statistics you can get a lot of info, there is a good article on this there:

http://www.javalobby.org/java/forums/t19807.html

and it seems that you can do stuff like:

QueryStatistics queryStats = stats.getQueryStatistics("from Sale sale");
// total hits on cache by this query.
queryStats.getCacheHitCount();

If this is not enough I once played with overloading StandardQueryCache, look at the get method



* rate if this helps *

This is a great tip. Thank you so much.

Hung-