[thelist] i'm going bonkers

[david.landy at somerfield.co.uk]

please help, i'm about to seek psychiatric advice...

has anyone seen anything like this? i'm trying to count the rows in a java
resultset. moving to the last record using last()and getting the row number
with getRow() returns 5. the trouble is there are really 19 rows in the
resultset, and iterating through them reveals this.

the next() method is also incorrectly returning false after row 5, and
isAfterLast gives a spurious true, as well.

bizarrely: 

<code>
    while (true) {
        rs.next();
        for (int i = 0; i < md.getColumnCount(); i++) { //md is resultset
metadata
            String t = rs.rs.getString(i + 1);
        }
        rows++;
        out.println("rows:" + rows + "<br>");
    }
</code>

iterates correctly through all 19 rows in the resultset, and bombs out on
the 20th (non-existent) row -- the error is expected and caught.)

however:

<code>
    while (true) {
        rs.next();
        String t = rs.rs.getString(1);
        rows++;
        out.println("rows:" + rows + "<br>");
    }
</code>

iterates only to row 5 and then bombs out.

ideas, anyone?

setup: apache/tomcat, winnt4, jdk 1.4.2

thanks in advance for any help/pointers.

david
-- 
 
If you are not the intended recipient of this e-mail, please preserve the
confidentiality of it and advise the sender immediately of any error in
transmission. Any disclosure, copying, distribution or action taken, or
omitted to be taken, by an unauthorised recipient in reliance upon the
contents of this e-mail is prohibited. Somerfield cannot accept liability
for any damage which you may sustain as a result of software viruses so
please carry out your own virus checks before opening an attachment. In
replying to this e-mail you are granting the right for that reply to be
forwarded to any other individual within the business and also to be read by
others. Any views expressed by an individual within this message do not
necessarily reflect the views of Somerfield.  Somerfield reserves the right
to intercept, monitor and record communications for lawful business
purposes.