Query cache - session ?

noash · **Joined:** Tue Dec 20, 2005 12:36 pm **Posts:** 2

Hello,

I turn on the second level cache and the query cache.

I have a question about query cache :

Here is the test I run :
- I make a query => the result is placed in cache
- I close my hibernate session
- I get a new session
- I execute the same query, Hibernate asks again the database => And here, I hope that the result woud be retrieved from the query cache

But if I make that way, it works :
- I make a query
- The result is cached
- I execute again the same query => And here, I hope that the result woud be retrieved from the query cache

Is it the way it should work ? only with the session still open ?

kgignatyev · **Posted:** Thu Dec 29, 2005 1:56 pm

Query cache is not in session scope.

http://www.hibernate.org/hib_docs/v3/re ... querycache

Quote:

Most queries do not benefit from caching, so by default queries are not cached. To enable caching, call Query.setCacheable(true). This call allows the query to look for existing cache results or add its results to the cache when it is executed.