File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Reading ResultSet data Batch Wise
Joined: Jun 22, 2009
Dec 09, 2009 01:53:24
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 ??
author & internet detective
Joined: May 26, 2003
Dec 09, 2009 20:21:17
You could use the technique "paging" uses where you query for 100 rows at a time.
OCA 8 book
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Joined: Feb 24, 2006
Dec 09, 2009 22:09:32
This article details some possible approaches including an example of a query that fetches only X rows at a time.
SCJP 6 articles
SCJP 5/6 mock exams
More SCJP Mocks
I agree. Here's the link:
subject: Reading ResultSet data Batch Wise
When to commit
Problem with BATCH UPDATES
how to get num of rows in ResultSet
Can i process iterator in parallel?
Improve Performance by Best design
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015