-----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]
