aspose file tools*
The moose likes JDBC and the fly likes How ResultSet works Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How ResultSet works" Watch "How ResultSet works" New topic
Author

How ResultSet works

wrushasen dakhane
Ranch Hand

Joined: Sep 25, 2006
Posts: 47
Hi All,

I know that the implementation of ResultSet and all the JDBC API is provided by the vendor specific drivers For ex: classes12.jar

Consider the senario where the select statement returns 1 million rows how it will handled by the ResultSet...

Wrushasen D


SCJP 1.4, SCWCD 1.4
Nitesh Kant
Bartender

Joined: Feb 25, 2007
Posts: 1638

Originally posted by wrushasen dakhane:
Consider the senario where the select statement returns 1 million rows how it will handled by the ResultSet...


Hi, Firstly, do not cross post the same question in different forums.
Coming to your question. I assume, you are asking that how many rows will be fetched by the ResultSet if there are a huge number of rows in the SQL statement execution result.
If so, then there is something called fetchSize of the resultset. You can set it explicity on a statement or a result set. This link will give you an initial idea.
[ April 04, 2007: Message edited by: Nitesh Kant ]

apigee, a better way to API!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How ResultSet works
 
Similar Threads
Count in ResultSet
How can I transfer Image between client and server side in RMI
how can I get Record Count from ResultSet?
resultset size
state of ResultSet