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.