Originally posted by David Chan: How can I check to size of the resultset or no. of row return without traversing the whole resultset?
If you have a JDBC 2.0 scrollable result set, you should be able to go to the last row (last()) and then get the current row number (getRow()). I'm not sure if that would be more efficient than doing a count(*) query first or not - give it try and tell us what you found. - Peter