any issues with SQL arrays of decimals? - Mailing list pgsql-jdbc

From Richard Welty
Subject any issues with SQL arrays of decimals?
Date
Msg-id E18mfor-0003Oh-00@skipper.averillpark.net
Whole thread Raw
Responses Re: any issues with SQL arrays of decimals?
List pgsql-jdbc
i have a bunch of code that was working with integer arrays which i just
converted to work with decimals.

the array is in the database correctly. from psql, target_percentages is:

 {0.08,0.08,0.09,0.08,0.08,0.09,0.08,0.08,0.09,0.08,0.08,0.09}

from my java code:

  target_percentages = (BigDecimal[]) result.getArray( "target_percentages").getArray();

which is producing the following exception:

SQLException: Bad BigDecimal 0.08

this code worked when it was an array of ints, and 0.08 is hardly a bad
BigDecimal.

this is postgresql 7.2.1-5 from an rpm on redhat 7.3, using the pgjdbc2.jar
driver from october of  last year. the jdk is 1.4.1_01

any suggestions?

thanks,
  richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
              Unix, Linux, IP Network Engineering, Security

pgsql-jdbc by date:

Previous
From: Paul Guermonprez
Date:
Subject: connect with a tunnel JSSE ?
Next
From: Richard Welty
Date:
Subject: Re: any issues with SQL arrays of decimals?