Exception throws when using Array

From: <whchung(at)popularworld(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Exception throws when using Array
Date: 2002-12-30 07:20:14
Message-ID: 001801c2afd3$e60a7340$71327f81@joey
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
We 're using PostgreSQL 7.2.1 and JDK1.4.0_01. We 've designed a table having a Numeric Array field. When trying retrieve the value using ResultSet.getArray().getArray() method, it works fine that we can retrieve an array of type BigDecimal if all the values contain in the array are all integer. However, we find that if there exist a value contain a decimal value(eg. 10.01), a Bad Decimal Exception is thrown, is it a bug or anything we can do to prevent the exception being thrown ? Thanks very much.

Regards,
Ricky.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Campano, Troy 2002-12-30 16:22:21 batch example
Previous Message Pierre Routens 2002-12-29 19:21:16 Help + Postgresql 7.22