getBigDecimal problem - Mailing list pgsql-bugs

From svetsch@tradewinds-solutions.com
Subject getBigDecimal problem
Date
Msg-id OF80BE477F.E76433CE-ONC1256A15.004B9FA8@LocalDomain
Whole thread Raw
Responses Re: getBigDecimal problem  (Peter T Mount <peter@retep.org.uk>)
List pgsql-bugs
Hi,

We just find out a small bug with the getBigDecimal(int i) method in
ResultSet (postgresql 7.1 beta6)

Th symptom is :

We cannot read a decimal value with getBigDecimal() although, we can set it

We solve the problem temporary by replacing the source original method

    public java.math.BigDecimal getBigDecimal(int columnIndex) throws
SQLException
    {
      // Now must call BigDecimal with a scale otherwise JBuilder barfs
      return getBigDecimal(columnIndex,0);
    }

by

    public java.math.BigDecimal getBigDecimal(int columnIndex) throws
SQLException
    {
      // Now must call BigDecimal with a scale otherwise JBuilder barfs
      return getBigDecimal(columnIndex,-1);
    }

So it does not perform a setScale in the method getBigDecimal(int column,
int scale)

It works well for us.


--
Samuel Vetsch
Trade Winds Solutions
36, rue du XXXI Décembre
CH - 1207 Genève
http://www.tradewinds-solutions.com

pgsql-bugs by date:

Previous
From: Stephen van Egmond
Date:
Subject: Re: comments on columns aren't displayed by \dd
Next
From: "M, Eichhorn"
Date:
Subject: Re: Some regression tests are failed RH7.0