This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
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).