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.