Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to set arraysize for jdbc thin connections?
Thanks Anurag.
Anurag Varma wrote:
> <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 Wed Jan 26 2005 - 21:12:07 CST