null items in a record set

[sde]

how do i handle a null item in a record set? for example:

while(rs.next()){
  int i = rs.getInt("FIELD_THAT_IS_NULL");
}

i keep getting sql exceptions when i try to use rs.getInt on a field that is null.

[sde]

ok, well a work around is to put that code in a try/catch block .. but isn't there a better way to test if a field of a recordset is valid?

[Belisarius]

According to the documentation, if the field is null, the value returned is 0. So something wacky is going on there.

[sde]

wacky was me. it returns 0, i thought i had isolated it to that one line of code, but it was another field that i was naming wrong.