This week's book giveaway is in the Agile forum.
We're giving away four copies of The Software Craftsman and have Sandro Mancuso 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 The Software Craftsman this week in the Agile 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.
Have you tried LearnNowOnline?
subject: Row count for an update statement