Retrieve the rowCount Without Looping

    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 the
resultset.
      int rowcount = rs.getRow();

      // Reposition at the beginning of the ResultSet to take up rs.next()
call.
      rs.beforeFirst();
      ...
      ....

    }
    catch(..)
    {
	..
    }