MySQL Forums
Forum List  »  Connector/JDBC and Java

Re: TYPE_FORWARD_ONLY, CONCUR_READ_ONLY and setFetchSize
Posted by: Filipe Silva
Date: September 24, 2017 06:39PM

Hi Rafael,

The forward-only fetching mode in the ResultSet is not affected by the fetch size you set. So, you can set whatever fetch size value you want, but those values will effect row fetching in different ways:

- when using cursor based server-side prepared statements (SSPS), i.e., "useServerPrepStmts=true&useCursorFetch=false", the fetch size is actually used to retrieve that number of rows from the server every time a new batch is required.

- when using non-cursor based SSPS or client side statements (prepared or not) the fetch size value affects the number of rows a ResultSet holds simultaneous in memory, i.e., if fetch size is set with Integer.MIN_VALUE then only one row at a time, otherwise all rows are read at once.

IHTH

Options: ReplyQuote


Subject
Written By
Posted
Re: TYPE_FORWARD_ONLY, CONCUR_READ_ONLY and setFetchSize
September 24, 2017 06:39PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.