niranjanwe

 Profile Answers by niranjanwe 

• Jun 24th, 2010

 

You cannot disable Query Cache because it is compulsory.

sowdri

 Profile Answers by sowdri 

• Jan 29th, 2011

 

Query cache depends on L2 cache.
L2 cache does not depend on query cache.
So nothing would happen.

Alternatively:
What will happened if level 2 cache is disabled and query cache is enabled in
Hibernate?

Answer:  Hibernate query can return both value types and entity types.

Query cache saves the id of entity types and complete value types.
When the same query is executed again, value types and entity type ids are
fetched from query cache.
From L2 cache, entity types are fetched using the ids.
so, if L2 cache is disabled, the entities are looked up from the database using
SQL queries using the IDs.