On Tue, 18 Jul 2006, jennie browne wrote:
> We have a prepared statement example below:
>
> With no dynamic parameters populated during runtime it will return
> roughly 1million rows. During execution of the query the
> preparedStatment grows in size up to 80MB and beyond.
>
> We have the fetchSize set to 1000
> And autocommit set to false.
>
> And the following params set
>
> stmt =
> conn.prepareStatement(query,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
>
setFetchSize will only work with ResultSet.TYPE_FORWARD_ONLY. It has no
effect on scrollable ResultSets.
Kris Jurka