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

Reply via email to