setArray

From: Alex Stienstra <alex(dot)stienstra(at)zonnet(dot)nl>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: setArray
Date: 2007-02-16 10:51:03
Message-ID: 20070216115103.8tagbdi2edy8g8kk@webmail.versatel.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

Iam trying to set an array in a prepared statement like this:

PreparedStatement stmnt = ds.prepareStatement(
"INSERT INTO trainingen (\"Atleet\", \"Datum\", \"Tijdstip\",
\"Afstand\", \"Tijd (Zone)\") VALUES (?,?,?,?,?)"
);
stmnt.setString(5, "{1,2,3,4,5,6}");

Assuming that the 5th parameter is an array of integer i get the follow
error message:

ERROR: column "Tijd (Zone)" is of type integer[] but expression is of
type character varying

I understood from previous discussions that the driver underwater will
convert the parameter of setArray
into a string representation like i do in the example above. I there
any other way of setting an array
field in a prepared statement?

Alex.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message j.random.programmer 2007-02-17 07:54:16 Bug in metadata.getColumns()/ORDINAL_POSITION
Previous Message Ken Johanson 2007-02-16 04:39:42 Re: Synthesize support for Statement.getGeneratedKeys()?