from the documentation of java.sql.Statement:
"public void setMaxRows(int max)
throws SQLException
Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped.
Parameters:
max - the new max rows limit; zero means unlimited"
...if your
jdbc driver supports this method. If it doesn't you may have to hit your database documentation to find out what the database specific notation is for your database(if it has one).
Jamie