PreparedStatement and setting an array is now broken - Mailing list pgsql-jdbc

From Andrew Lazarus
Subject PreparedStatement and setting an array is now broken
Date
Msg-id 41C9EFE2.7030108@attglobal.net
Whole thread Raw
In response to Re: CallableStatement: java.sql.Types=12 however type java.sql.Types=1111  (Jerome Colombie <jcolombie@gmx.ch>)
Responses Re: PreparedStatement and setting an array is now broken
List 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 by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Bug in JDBC-Driver?
Next
From: Kris Jurka
Date:
Subject: Re: [BUGS] BUG #1347: Bulk Import stopps after a while (