setArray
От | Alex Stienstra |
---|---|
Тема | setArray |
Дата | |
Msg-id | 20070216115103.8tagbdi2edy8g8kk@webmail.versatel.nl обсуждение исходный текст |
Ответы |
Re: setArray
|
Список | 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.
В списке pgsql-jdbc по дате отправления: