Hello,
columns with type "money" are reported as Types.DOUBLE by the JDBC driver.
However using ResultSet.getDouble() (or getObject()) on those columns throws an error:
Bad value for type double : €100,00
(SQL State=22003)
It seems that for money columns, only getString() works properly which doesn't really make sense. It breaks
applicationswhich assume that ResultSet.getDouble() can be used on a column that is identified as Types.DOUBLE
I would at least expect ResultSet.getObject() to work properly on those columns.
Regards
Thomas