Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Initial rows loaded to result set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Initial rows loaded to result set" Watch "Initial rows loaded to result set" New topic
Author

Initial rows loaded to result set

Joe Nguyen
Ranch Hand

Joined: Apr 20, 2001
Posts: 161
I notice that the default intial loading in result set is 10 rows. It always happens regardless how many rows being set in the setFetchSize(). Does any one know how to alter the initial loading.
Joe Nguyen
Ranch Hand

Joined: Apr 20, 2001
Posts: 161
Let me answer my own question since I just find out the answer. Set fetch size to the statement.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Initial rows loaded to result set
 
Similar Threads
incorrect results returning from my DB
Counting number of rows in resultset
How come I know number of rows in a Result Set ?
How ResultSet works
Row count in MySQL