• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading ResultSet data Batch Wise

 
girraj meena
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All

I have to read REsultSet in a batch.Since My resultSet size quite Huge .
How i can read suppose batch size =100 ..100 records at time ...then apply business rule
then move to next batch ??
Regards
Girraj
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34669
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Girraj,
You could use the technique "paging" uses where you query for 100 rows at a time.
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This article details some possible approaches including an example of a query that fetches only X rows at a time.

http://www.javaranch.com/journal/2008/08/Journal200808.jsp#a4
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic