Re: Help with JDBC

From: Lewis C <lewisc_at_excite.com>
Date: Fri, 15 Apr 2005 09:10:12 GMT
Message-ID: <3s0v51t8t2p2pa32e5i3q57u9nkpulct1h@4ax.com>

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

Received on Fri Apr 15 2005 - 04:10:12 CDT