any issues with SQL arrays of decimals?

From: Richard Welty <rwelty(at)averillpark(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: any issues with SQL arrays of decimals?
Date: 2003-02-22 20:00:21
Message-ID: E18mfor-0003Oh-00@skipper.averillpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Unix, Linux, IP Network Engineering, Security

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Richard Welty 2003-02-22 21:47:24 Re: any issues with SQL arrays of decimals?
Previous Message Paul Guermonprez 2003-02-21 16:38:58 connect with a tunnel JSSE ?