Thanks, I just did a few experiments and found the same thing, that getFetchSize() was returning 0. Is there anything else I could use to achieve the same result, namely how many rows in the select ?? I am very new to DB programming that�s why I probably misread the documentation on getFetchSize().
Ranjeet
Kris Jurka <books@ejurka.com> wrote:
On Fri, 20 Feb 2004, Ranjeet Kapur wrote:
> Hi,
>
> ResultSet rs = select_stmnt.executeQuery(query);
> System.out.println("Select Size = " + rs.getFetchSize());
> num_entries = rs.getFetchSize();
>
getFetchSize does not return the number of result rows. It did prior to
7.4, but that was just an implementation artifact and should not have been
relied on.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.