PreparedStatement and setting an array is now broken

From: Andrew Lazarus <drlaz(at)attglobal(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PreparedStatement and setting an array is now broken
Date: 2004-12-22 22:06:26
Message-ID: 41C9EFE2.7030108@attglobal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-12-22 23:18:12 Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
Previous Message Oliver Jowett 2004-12-22 21:22:59 Re: Bug in JDBC-Driver?