Re: How to set arraysize for jdbc thin connections?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 19 Jan 2005 05:10:03 GMT
Message-ID: <LYlHd.150248$Uf.6079@twister.nyroc.rr.com>

<wagen123_at_yahoo.com> wrote in message news:1106100635.622459.197440_at_z14g2000cwz.googlegroups.com...
> Hi,
>
> I would appreciate if anyone could tell me how to set the arraysize for
> connections made by jdbc thin driver. I gather that the default is 10.
>
> Similar to the "set arraysize" for sqlplus (via glogin.sql).
> Thanks very much.
> wagen
>

Read the Fine Manual: Try jdbc doco at tahiti.oracle.com

I believe the feature you are looking for is Row Prefetching. The api I think is setdefaultrowfetch(<rows>)

Anurag Received on Tue Jan 18 2005 - 23:10:03 CST