Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group