I have the query cache on MySQL 4.0.13-standard running and working fine, with a
large amount of memory allocated to it. But it doesn't appear to be working with
the MySQL JDBC driver access. I have used versions 2.0 and 3.0 of the JDBC
driver. Although it will cache a query from the JDBC driver, it won't use the
cache when the it sends the same query. Does anyone have any clues why this is?
I read somewhere that there's a problem when the driver uses compiled prepared
statements and can't access the cache then, but other than that it should use
the query cache, right?
Thanks