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
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 ? |