PreparedStatement and setting an array is now broken

Поиск
Список
Период
Сортировка
От Andrew Lazarus
Тема PreparedStatement and setting an array is now broken
Дата
Msg-id 41C9EFE2.7030108@attglobal.net
обсуждение исходный текст
Ответ на Re: CallableStatement: java.sql.Types=12 however type java.sql.Types=1111  (Jerome Colombie <jcolombie@gmx.ch>)
Ответы Re: PreparedStatement and setting an array is now broken
Список pgsql-jdbc
Until version 8 (now using build 308), I used a prepared statement

INSERT INTO mytable(array_column) VALUES(?);

and

setString(1, my_formatter(java_array));

where my_formatter turns a Java double[] into a string in the form {1.0} .

This doesn't work any more, with the error message that character
varying can not be converted to real[] . I think it's with the driver,
because the braces form still works fine with psql. I changed the
formatter to produce a string in ARRAY[1.0] notation with the same error
message.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: Bug in JDBC-Driver?
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: [BUGS] BUG #1347: Bulk Import stopps after a while (