Re: TYPE_FORWARD_ONLY, CONCUR_READ_ONLY and setFetchSize

[Filipe Silva]

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