Hi all
I am sure this has been asked before, but i can't seem to find the answer.

the methods that get objects from java.sql.ResultSet  return primitive
types.
what if the value was null in the database?
rs.getDouble(columnName) will return 0

what is the correct way or getting values from the result set?

i wrote a utility function as shown below where i pass it the resultset and
the column name, and it will preserve the null value and return an object
Double for me.
is this the correct way of doing it?
i like to know what others do.
here is the utility function that i wrote which replaces the
rs.getDouble(String columnName)

private Double getResultSetDouble(java.sql.ResultSet rs, String columnName)
throws java.sql.SQLException{
       Object o = rs.getObject(columnName);
       if(null==o)
           return null;
       return new Double(rs.getDouble(columnName));
   }

thanks
hilz