Re: Bug extracting money value

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Holger Schulz <hst1(at)online(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug extracting money value
Date: 2006-10-01 21:11:33
Message-ID: 45202F05.4050602@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2006-10-01 21:15:49 Re: Problem : Sql queries are created in lowercase
Previous Message Josep 2006-10-01 18:47:00 Problem : Sql queries are created in lowercase