Use this code to obtain the rowcount in JDBC without looping through the resultset.
try { // Create a scrollable result set. stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); // Set a string with the query sqlString = "SELECT ....."; rs = stmt.executeQuery(sqlString); // Point to the last row in resultset. rs.last(); // Get the row position which is also the number of rows in theresultset. int rowcount = rs.getRow(); // Reposition at the beginning of the ResultSet to take up rs.next()call. rs.beforeFirst(); ... .... } catch(..) { .. }