*
The moose likes JDBC and the fly likes HANDLING RESULTSET Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HANDLING RESULTSET" Watch "HANDLING RESULTSET" New topic
Author

HANDLING RESULTSET

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi all,
i am having a small issue which is as follows:
After an execute query the datas are in the resultset
and to access them we scroll through the resultset using the
next() method for every row but this is a time consuming affair
more so since we have to handle a large volume of data and is almost taking 1-2 mins to scroll through the entire result set..
So is there any way we can extract the entire data in a single go
so that the time lost in calling next() in a while (true) loop
is saved .
thanx in advance

anirvan
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
well there is no way to traverse across the resultset without the next statement.
A better way to improve the performance is to optimise your query so that number of records in the results are reduced.


Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
 
Don't get me started about those stupid light bulbs.
 
subject: HANDLING RESULTSET