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.