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

On Thu, 14 Apr 2005 22:31:30 -0400, nospam <nospam (AT) goaway (DOT) com> wrote:

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
-----------------------------------------------------------

Thanks for your help Lewis!

ty

In article <3s0v51t8t2p2pa32e5i3q57u9nkpulct1h (AT) 4ax (DOT) com>, Lewis C
<lewisc (AT) excite (DOT) com> wrote: