setFetchSize() ?

[Sahina Celin]

Hi,

Im using setFetchSize() in my code, but it doesnt have any impact.
I wanted to retrieve first 30 records first , then next 30 like that.
Once i got first 30 records im returning it as a collection , then in main program im checking if the size of the coolection is not zero retrive next 30 records.

But rs.setFetchSize(30) is retrieving all my records in the first execution itself. How can i implement this functionality with or without using rs.setFetchSize()

Any kind of help is appreciable.
Thanx

[JulianInactive KennedyInactive]

Sahina,

You probably need to setFetchSize() on your Statement first. By the time you've got your ResultSet, after the execute, to setFetchSize() on it, all the rows have already been retrieved. As I understand it setFetchSize() is available on ResultSet to allow you to change the fetch size after the initial execute.

Jules