Hello,

I have developed a website having registration and search functionality. User can search for a variety of a parameters. How can I use hibernate cache for data read queries.

Ex:
<![CDATA[from PersonalInfoBean c WHERE (c.year >= ? and c.year <=?) and (c.height >= ? and c.height <=?) and c.gender = ? and enable='Y' ORDER BY lastLoginTime DESC) ]]>

I am already using
query.setCacheable(true);
query.setCacheRegion("query." + queryString);

Thanks
!TechByte

You would also need some ehcache.xml configuration file (or other caching library of your preference). If none found, Hibernate uses the default, which is included in its jar.

Note that query caching might not be very useful in your case, since it is mostly used in cases where few queries with the same parameters are executed. Your case is the opposite: that query can adopt a wide combinatory of parameters!
The cache will store only so many pairs "combination of parameters-resultset" before running out of space.

I don't think it makes much sense naming extra cache regions after your queries' SQL code. Either don't define any region, or use something more meaningful. Also notice that those eccentric "regions" would not be defined in the default cache configuration file ehcache.xml