File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Customer Requirements for Developers
this week in the
JDBC and Relational Databases
Joined: Jun 21, 2001
Dec 08, 2004 13:17:00
API documentation the description for the above method is:
public int getFetchSize()
Retrieves the fetch size for this
What is a fetch size? is it the numbe rof return row counts?? or the numbe r of column row count from which the data is fetched?
I think the second ans is right. wanted to confirm.
Joined: Dec 08, 2004
Dec 08, 2004 14:56:00
None of them
Fetch size is the number of rows that should be fetched from the database when more rows are needed.
If a fetch size has not been set by calling the method setFetchSize, the return value is implementation-specific.
I agree. Here's the link:
Optimize Oracle Performance?
Paging in JDBC 2
Table Row slection programmatically
Reg: Fetch Size
Which design pattern JDBC-Resulset implements : Bridge, iterator, composite, factory
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015