Hibernate version: 3.1

Name and version of the database you are using: mySQL 5.0.11

We are currently wrinting something using Jboss, Hibernate and mySQL and we were looking at caching strategies. mySQL provides some nice fast QueryCaching that we had used before. We did a nice simple operation in Hibernate and right enough the query shows up in the mySQL logs. The strange thing is it never hits the mySQL QueryCache, if we execute the query form the log in query browser then it hit the Querycache fine, but no query from Hibernate is being cached.

I've been searching though the documentation but I can't find any referneces as to why this might be in either Hibernate nor mySQL documentation. Is it more worth our while ignoring the mySQL caching and concentrate on Hibernate second level cache.

Thanks for your help in advance.

Andrew Aitken

I have similar issues (please see my other post)... Did you get anywhere?

My findings are it caches query results until you start updating - then it's DB hits all the way.