getBigDecimal problem

From: svetsch(at)tradewinds-solutions(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: getBigDecimal problem
Date: 2001-03-20 13:54:01
Message-ID: OF80BE477F.E76433CE-ONC1256A15.004B9FA8@LocalDomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Isabelle Therrien 2001-03-20 14:53:45 Re: important decrease of performance using the BETA version in one particular case
Previous Message gwcom 2001-03-20 11:03:46 Bugs on COPY command