Re: Bug extracting money value - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Bug extracting money value
Date
Msg-id 35A36432-5E5A-4A44-8C9E-6F66F76F56D3@fastcrypt.com
Whole thread Raw
In response to Re: Bug extracting money value  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
On 1-Oct-06, at 5:11 PM, Oliver Jowett wrote:

> Holger Schulz wrote:
>
>> I always get an exception when I try to extract the money value I
>> inserted this way:
>
> "money" isn't a well-supported type on the server side (I believe
> its use is no longer recommended)
This is still being debated, and will likely be reversed as there is
a proposal on the table for a new improved money type

> .. IIRC the formatting rules for it are locale-specific, among
> other problems.
>
>> Object oValue = m_resultSet.getObject(i);
>
>> org.postgresql.util.PSQLException: Bad value for type double : ?7,00
>
> ... though I'd expect at least getObject to work, if not getDouble()
>
> Maybe you could dig into this and send us a patch?
>
> -O
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>


pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Bug extracting money value
Next
From: Heikki Linnakangas
Date:
Subject: XA end then join fix for WebLogic