This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I'm using Hibernate with Spring framework, and trying to cache a query which is written through the CriteriaAPI. I've enabled the query cache and the 2nd Level cache. I've also set the setCacheable to true in that particular query. The problem is that hibernate session statistics show that it hits the database everything for the same query I'm running multiple times.
Here's the function with the criteria query
here's the caller function
ehcache portion of this class
I'm fairly new to Spring and Hibernate. I've read at least a dozen articles regarding this issue and did everything that I could. Also, I wrote a similar query using createQuery method, the result was the same. Any help would be appreciated.