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.
You could use
ReplyDeleteString str = String.valueOf(resultSet.getObject("col1"));
as a simple workaround to avoid any exceptions. (Not sure why you can't use resultSet.getDouble("col1") though.)
If you don't want to see an empty string rather than the literal "null" for a null value (which is what String.valueOf()) will produce, you can use:
ReplyDeleteObject value = resultSet.getObject("col1")
String str = value == null ? "" value.toString();