any issues with SQL arrays of decimals?
От | Richard Welty |
---|---|
Тема | any issues with SQL arrays of decimals? |
Дата | |
Msg-id | E18mfor-0003Oh-00@skipper.averillpark.net обсуждение исходный текст |
Ответы |
Re: any issues with SQL arrays of decimals?
|
Список | 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 по дате отправления: