Bug when retrieving money datatype. - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Bug when retrieving money datatype.
Date
Msg-id jb3j7b$s3p$1@dough.gmane.org
Whole thread Raw
Responses Re: Bug when retrieving money datatype.
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: eclipse update source?
Next
From: Oliver Jowett
Date:
Subject: Re: Bug when retrieving money datatype.