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 Greg
