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.
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()? |