-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Al Caponi wrote: > Hi again, > The query cache finally works after I've reverted to > mm.mysql-2.0.12-bin.jar. > > The problem was that the query cache somehow wouldn't work within > transactions with mysql-connector-java-3.1.10-bin.jar. Anyone care to dig > further?
Al, It's not that they don't work with transactions, it's that MySQL doesn't cache server-side prepared statements, which are enabled by default with Connector/J 3.1.x when connected to MySQL-4.1.x or newer. You can turn them off by adding "useServerPrepStmts=false" to your URL configuration properties for Connector/J 3.1.x, and MySQL should be able to utilize the query cache again. It's planned that in the future the query cache will work with server-side prepared statements, but for now the above is a workaround. -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDRzXytvXNTca6JD8RAmlFAJ9c5TLx4O0jwrmvvgcs5sNkw2r60ACgpGkk TUHFCfWAhUWnpITUmnKaDW8= =Zh7V -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]