j2sdk1.4.2_03 getXXX() methods in ResultSet

From: _chasers (jikken_at_msn.com)
Date: 01/16/04 

Date: 16 Jan 2004 10:49:53 -0800

I don't remember it being like this when using ResultSets in the past,
but when using j2sdk1.4.2_03 on Windows NT, it seems that I can only
call a rs.getXXX() method once per iteration. For example, if I do:

while (rs.next()) {
  String s = rs.getString("Field1");
  if (s != null && s.length() > 0)
    System.out.println(s);
}

then everything works okay. But if I do:

while (rs.next()) {
  if (rs.getString("Field1") != null &&
((String)rs.getString("Field1")).length() > 0 )
    System.out.println(rs.getString("Field1"));

then it either returns an empty ResultSet or only 1 row before
throwing an exception. Did anyone else run into this problem?

Thanks