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 » Java » 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
posted private message
0
Quote
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
posted private message
0
Quote
Let me answer my own question since I just find out the answer. Set fetch size to the statement.
 
 
subject: Initial rows loaded to result set
 
Threads others viewed
How come I know number of rows in a Result Set ?
incorrect results returning from my DB
Counting number of rows in resultset
How ResultSet works
Row count in MySQL
developer file tools