-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Johan Höök wrote:
Hi all,
is there some sort of query cache within the Connector/J driver
for ResultSets?
Johan,
No, there is not.
I have a query which when it's run from within Java returns
an old invalid ResultSet. If I execute the same statement
from outside Java, i.e. direct into MySQL I get the correct
ResultSet.
The tables in the select are modified via the same connection that
is later queried ant returns the "old" result.
Are you using InnoDB tables? If so, maybe you're retrieving an 'old'
snapshot (InnoDB uses multiversion concurrency control) because you've
never committed your current transaction?
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
MySQL User Conference (Santa Clara CA, 18-21 April 2005)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCODbstvXNTca6JD8RAmszAJ41jk3bGjduQ6DCdzmNVLTlmgJUvACfUQYM
KK8XJV6LTh0oX58qPBwNipw=
=g+td
-----END PGP SIGNATURE-----
3 messages in com.mysql.lists.javaRe: Connection caching ResultSets?
