I am using setFetchSize to limit the rows returned by query.
Here is Code without using setFetchSize -
Statement stmt = dao.createStatement();
ResultSet rset = stmt.executeQuery("SELECT * FROM temp");
while(rset.next ())
System.out.println( rset.getString (1) );
Code using setFetchSize -
Statement stmt = dao.createStatement();
stmt.setFetchSize(20);
ResultSet rset = stmt.executeQuery("SELECT * FROM temp");
while(rset.next ())
System.out.println( rset.getString (1) );
both the code returns same result. temp has has 50 records and all records are returned in both the cases.
Edited by: seeking_solution on Jul 22, 2009 5:25 AM