This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Row count for an update statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Row count for an update statement" Watch "Row count for an update statement" New topic

Row count for an update statement

kartik krishnan
Ranch Hand

Joined: Nov 19, 2006
Posts: 63
Consider a hypothetical situation where I have a table t_number with only two columns name varchar(30) and number int(10),

In my JDBC code, I am executing a sql query

From the api, we know that the rowCount will return the number of rows updated. Does the row count include the rows where the number column's previous value was 2? I am waiting for my laptop to arrive from Dell so I have not been able to test this yet. But I want to know this urgently.
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
It returns only the actually affected rows, thus when the previous value wasn't the same.
I agree. Here's the link:
subject: Row count for an update statement