Looking at the changelog for the MySQL Connector/J I find an entry
from 2003 saying that getUpdateCount now returns the number of matched
rows rather than the number of affected rows. Unfortunately, I need
the latter.

In the bugs database I found that a function has been added to MySQL
5.0 which allows you to extract the number of affected rows from the
previous query, but as I run 4.1 that is not an option.

After some searching I found this post:
http://lists.mysql.com/java/6027 which initially gave me some hope,
because I run Connector/J 3.1. But alas, I have not been able to
locate any such parameter. Am I overlooking something, or has this
parameter not been added? Or is there some other way of extracting the
number of affected rows after executing an update?

And just to make sure there's no misunderstandings: by affected rows I
mean the value that you get in the "Changed" field when you execute an
update in the client.

Andr=E9 N=E6ss

--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=3D...ie.nctu.edu.tw

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

André Næss wrote:
Andre,

The issue is that the JDBC specification requires _matched_, not changed
to be returned from Statement.executeUpdate().

I've yet to add the parameter (sorry), so until then you can either
upgrade to 5.0, or run the query as a SELECT with the same WHERE clause
to determine what row count would be returned.

-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDT7U+tvXNTca6JD8RAvnXAJ9yeHaFgIEeqF++tnfKQq d5288s1QCgrsfw
6P1b7rPFA5SdYgvBumrmQ9I=
=iOq+
-----END PGP SIGNATURE-----

--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw