ResultSet when no rows found

[Martin Lira]

Hi,
I have some jdbc code

  
ResultSet rs = stmt.executeQuery("select * from table");
while(rs.next()){
}
rs.close();

Is the ResultSet null when the result is "no rows found", will rs.close() give me an error.

Thanks,
Martin

[Jeanne Boyarsky]

Martin,
The resultset is never null. So rs.next() will return false and rs.close() will close the empty resultset.