• 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
Sheriff
Posts: 36032
432
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
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!