Hello,
I'm wondering about second level cache: I'm trying to activate it and to see the performance after execution with cache. I think that a first level cache is associated to a session, and the second one is associated to the session Factory...

So, i have done necessary configurations in order to activate the second level cache, and i think it's ok and it's runing: this is the content of the region of my Customer class:




when i'm executing the same function "getCustomers" for the second time, in the same session, it doesn't generate all queries associated to collections, what is what i want, but i was surprised when i desactivate the cache, it do the same thing=> i deduced that it was the first level cache which was runing...

For this reason, i closed the session but still in the same sessionFactory, i execute the function "getCustomers()" and now it doesn't read from cache even, my second level is containing all data i want.... I put here the content if the statistic after:
1- executing 3 times the function ,
2-closing the session
3-Statistics are:


4- the call to the function leads to the execution of n+1 select to bring all collections....

Could you explain me please, what is wrong?

Thank you for help

There are many things to consider here before we can come to a conclusion:
1) Which implementation of Second Level Cache[SLC] are you using, Oscache etc.?
2) There are some configuration/coding changes needed.
a) Have the osache.properties in the classpath.[In case of Oscache]
b)hibernate.cache.use_query_cache=true
hibernate.cache.use_second_level_cache=true
hibernate.cache.provider_class=org.hibernate.cache.OSCacheProvider
c) Before executing the query:
getHibernateTemplate().setCacheQueries(true);
d) In the mapping file
<cache usage="read-only"/>

Now, the above code samples are just a guideline and assumes that your are using Spring
and a hibernate.properties file.

If your configuration is all set, you should be able to use the Second level Cache
without any problems.
Let me know.

this is la configuration of my file .cfg.xml:



and this my mapping file:



I have also my Ehcache.xml file:





I think the cache is runing while in the statistics it's written:

If you are running the cached-data-query again in "another session", you should see either the hit count or miss count going up. And it seems both of these are 0 for you.
Makes me wonder if you running the queries in the same session?

i'm running the queries in the same session factory but not in the same session, which is my goal...
It' runing now, i can't explain why, but i changed the usge to read-only and it worked!!!!
thank you for help