Hi everybody!

I'm new to hibernate and ehcache! I want to implement a hibernate second level cache. So I try ehcache.

I have created a simple table with 500 entries for test purposes. I also created the ehcache.xml conf file. For performance tests I implement a junit test case. This test case requested the result list (500 entries) five times. I run the application with and without ehcache for 2nd Level cache. But I get no optimization. The timer always shows the same time span.

Therefore I printed out the log file to be sure my second level cache was enabled. So I got the messages that every entry get cached. But also a sql query was executed and printed at the console. In my view the data comes from DB and not from ehcache. This is the reason why I don't get an optimization.

How can I get data from ehcache without execute a query?

Can anyone help me?

in addition:

This is my log:

16:01:57,518 DEBUG TwoPhaseLoad:107 - resolving associations for [Preview#1]
16:01:57,518 DEBUG TwoPhaseLoad:135 - adding entity to second-level cache: [Preview#1]
16:01:57,518 DEBUG ReadOnlyCache:55 - item already cached: Preview#1
16:01:57,518 DEBUG TwoPhaseLoad:206 - done materializing entity [Preview#1]
16:01:57,518 DEBUG TwoPhaseLoad:107 - resolving associations for [Preview#2]
16:01:57,518 DEBUG TwoPhaseLoad:135 - adding entity to second-level cache: [Preview#2]
16:01:57,518 DEBUG ReadOnlyCache:55 - item already cached: Preview#2
16:01:57,518 DEBUG TwoPhaseLoad:206 - done materializing entity [Preview#2] ............


the cached previews are already in the cache, but how can I avoid to execute sql query for another load. In my point of view the data should be retrieve from cache.

Please help me!