Result Set Default Fetch Size. If there are 10000 records rows to be transferred the JDBC driver. The getFetchSize method returns 0 to indicate the dynamic sizing.
This setFetchSize method is specified by the setFetchSize method in the javasqlResultSet interface. Limit the size of your result sets Consider using the setMaxRows method or SET ROWCOUNT or SELECT TOP N SQL syntax to limit the number of rows returned from potentially large result sets. The result set fetch size either set explicitly or by default equal to the statement fetch size that was passed to it determines the number of rows that are retrieved in any subsequent trips to the database for that result set.
JDBC - ResultSet fetch size.
This is because the default fetch size for a result set is usually 10. The default value for Statement or PreparedStatement is jdbc driver specific fetchSize is only a hint for the driver the Oracle driver respects this setting while other drivers may ignore it and fetch all the records at once for instance. T his limit exists because of a memory limitation inNET framework explained in section 4. You want your application to generate a result set for optimal performance and memory usageFor the IOM driver the default fetch size is calculated dynamically unless the fetch size is set manually with the setFetchSize method.