Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How ResultSet works

 
wrushasen dakhane
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Nitesh Kant
Bartender
Posts: 1638
IntelliJ IDE Java MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic