Statement stmt = con.createStatement();
stmt.setFetchSize(25);
ResultSet rs = stmt.executeQuery("select * from testgroup");

My actual table contains 1 million records. I want buffered data to be restricted to 25 rows at a time.

Does DB2 ver8.1 type 4 driver support this api, Statement.setFetchSize(int)?

Appreciate your feedback.