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

From Oliver Jowett
Subject Re: Bug extracting money value
Date
Msg-id 45202F05.4050602@opencloud.com
Whole thread Raw
In response to Bug extracting money value  (Holger Schulz <hst1@online.de>)
Responses Re: Bug extracting money value  (Markus Schaber <schabi@logix-tt.com>)
Re: Bug extracting money value  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
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) .. 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

pgsql-jdbc by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: Problem : Sql queries are created in lowercase
Next
From: Oliver Jowett
Date:
Subject: Re: Bug extracting bit value