I have a requirment where I am using ehcache for hibernate second level cache.
It works fine for me as long as i fetch objects by identifier using load() or get().
But I want to fetch a list of objects using some criteria, this time to goes to database.
I want it to fetch data from second level cache every single time, as I have pre loaded my table in cache.
I don't want to use query cache, please advise if I can achieve my target using Second Level cache only.