How do I get the size of a java.sql.ResultSet?
Do a SELECT COUNT(*) FROM … query instead. OR int size =0; if (rs != null) { rs.last(); // moves cursor to the last row size = rs.getRow(); // get row id } In either of the case, you won’t have to loop over the entire data.