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.
We are using Gemfire cache to store application data and if the data is not found in the cache, we try to get it from the MySQL database using hibernate.
The database call (When the cache does not have the data) is made from the class implementing CacheLoader interface's load method. The method seems to get called if we search the cache using an id. But how do we make sure the method gets called when we run a sql query against the cache? Or can we write an overloaded method or use a different interface maybe?
For example, this works fine:
But what do we do if its an sql query like:
Below is the class implementing the CacheLoader interface