I have configured hibernate query cache in my app. I want to use the query cache for one specific part of the application where in there is heavy database roundtrip. The query in question is SQL query (not HQL due to union clause) and is accessed a lot many times during one application flow.
We wanted to utilise queryCache for this scenario so accordingly we configured the hibernate cfg xml files
Also i have configured the hbm xml files with <class name="com.one.two.pakgname.hib.Xtable" table="XTABLE">
What I want to achieve is cache the data fetched by the queries. But time and again for every request I see the hibernate doing database roundtrips. I don't see the querycache getting into action at all.