Thread: Exception throws when using Array

Exception throws when using Array

From
Date:
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.