Skip to main content

Posts

Showing posts with the label resultset

ResultSet How to get strin from object when data is null?

In my Oracle table there are columns with different type. I want to read all columns as number. String str = resultSet.getString("col1"); The problem is that if column in database is defined as number, and value is 0.5 The returned string will be .5 I can not use any other getter like getDecimal and etc. if I use: String str = resultSet.getObject("col1").toString(); I'll get an exception if the value is null.