aspose file tools
The moose likes JDBC and the fly likes Initial rows loaded to result set Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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 ?
Row count in MySQL
How ResultSet works