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 по дате отправления:

Предыдущее
От: Paul Guermonprez
Дата:
Сообщение: connect with a tunnel JSSE ?
Следующее
От: Richard Welty
Дата:
Сообщение: Re: any issues with SQL arrays of decimals?