Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY

a better way to count the number of rows would be

rs=pstat.executeQuery();                //execute the query
rs.last();                              //move the cursor to the last row
int numberOfRows = rs.getRow();         //get the number of rows
rs.beforeFirst();                       //back to initial state