Re: Prepared Statement Memory Size

[Kris Jurka <books(at)ejurka(dot)com>]

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