Re: Help with JDBC

Thanks for your help Lewis!

ty

In article <3s0v51t8t2p2pa32e5i3q57u9nkpulct1h_at_4ax.com>, Lewis C <lewisc_at_excite.com> wrote:

> On Thu, 14 Apr 2005 22:31:30 -0400, nospam <nospam_at_goaway.com> wrote:
>
> >Hello all,
> >
> >I have a question about the Oracle 10g thin JDBC driver. I was
> >wondering if anyone knows what the default prefetch size is (in number
> >of rows). Also, does anyone know if an entire packet is sent (i.e.
> >padded with null values) if there is not enough data to fill it?
> >
> >Thanks for your help!
> >
> >ty
>
> Oracle defaults the prefetch to 10 rows. You can modify that using
> setRowPrefetch.
>
> I don't believe it will pad if not found. Seems kind of silly if it
> did. Wouldn't it then have null rows in the rowset? That's just a
> guess on my part though.
>
> Lewis
>
> -----------------------------------------------------------
> Lewis R Cunningham
>
> Author, ItToolBox Blog: An Expert's Guide to Oracle
> http://blogs.ittoolbox.com/oracle/guide/
>
> Topic Editor, Suite101.com: Oracle Database
> http://www.suite101.com/welcome.cfm/oracle
>
> Sign up for courses here:
> http://www.suite101.com/suiteu/default.cfm/416752
> -----------------------------------------------------------
Received on Sat Apr 16 2005 - 20:59:36 CEST