Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Statement.setfetchSize() Doubt Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Statement.setfetchSize() Doubt" Watch "Statement.setfetchSize() Doubt" New topic

Statement.setfetchSize() Doubt

Ravi Sree
Ranch Hand

Joined: Jan 24, 2010
Posts: 64

Hi all,

I am not fully fluent with the JDBC methods, so please guide me.
While using the methods Statement.setFetchSize(int i) or Resultset.setFetchSize(int i)
we can set the no of rows fetched at a time for all result sets of this statement.
This helps in decreasing the load on the db server. but if one has to fetch 100 rows and the fetch size is set.
how will the rest rows be fetched like...
for example i have a table 'testTable' which has a primary key Id.
when a query is executed the rows fetched will be rows till Id = 30 then next fetched rows should be from the primary key 31.
How is this understood by the db server.
I will be very grateful if some examples is provided.

Thanks in advance.
Prashant Saraf
Ranch Hand

Joined: Sep 25, 2006
Posts: 57

Check this out this may help

[moderator changed from code tag to url tag]
I agree. Here's the link:
subject: Statement.setfetchSize() Doubt
It's not a secret anymore!