We have been using TangoSol as secondary level cache.

How can i make sure that the data is retrieved from cache?

I am assuming that if the sql is not triggered then it retrieves
from cache?

Is my assumption is correct??


Hibernate version:
3.0.1
Mapping documents:
<property name="hibernate.cache.region_prefix">repl-</property>
<property name="hibernate.cache.use_second_level_cache">true</property>
<property name="hibernate.cache.use_structured_entries">true</property>
<property name="hibernate.generate_statistics">true</property>
<property name="hibernate.cache.use_query_cache">true</property>

<property name="hibernate.cache.provider_class">com.xx.xxxx.coherence.CoherenceCacheProvider</property>

<class-cache class="com.xx.xxxx.inventory.hibernate.schema.PropPrdtHVO" region="prdt" usage="read-write"/>

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt: