Resultset Fetch Size Java. A limited size result set should address the unbounded fetch size shortcoming while ensuring predictable. You should probably play with the fetch size a bit see the setFetchSize method in the Statement interface.
Im dealing with the rather classical problem to run a query against a DBMS and fetch ResultSets resulting data into Java classes. Many frameworks like Spring or Hibernate give you very convenient API to do this. The fetch size can be changed at any time.
The following examples show how to use javasqlResultSetsetFetchSize.
The fetch size may be changed at any time. If the fetch size specified is zero the JDBC driver ignores the value and estimates what the fetch size should be. In the following code shows how to use ResultSetgetFetchSize method. JDBC - ResultSet fetch size The value of fetch size is used to decide about the no.