title: How JDBC Statement.setFetchsize exactly works
body: <p>I want to implement <a href="https://developers.google.com/resources/api-libraries/documentation/bigquery/v2/java/latest/com/google/api/services/bigquery/model/QueryRequest.html#setMaxResults%28java.lang.Long%29" rel="nofollow noreferrer">this</a> methods functionality in my custom JDBC driver. Which method from JDBC should I use to setMaxResults?</p>
  <p>If my query results is 1000 rows and I have set the value for setFetchSize=100, then what will be the results? It will return only 100 row or after returning first 100 it will get next 100 from db until 1000 rows completed.</p>