Hey Dudes, Lets say stmt.setFetchSize(100) is executed and then ResultSet forms as a reult of a executeQuery() not if the query only returned 10 or 20 rows, whats the cleanist way to determine the actual number of rows present in the ResultSet at any valid instance. Love and Peace.
You could create a scrollable result set and jump to the last row and call getRow() method which returns the number of the current row (in this case last row).
a fool thinks himself to be wise, but a wise man knows himself to be a fool - shakespeare. foolish tiny ad: