I have a java application that moves data from our erp platform (progress) into a Postgres database. One of the fields in progress is a character array. I haven't had any luck getting this field to transfer. What I would like to do is something like:
.... preparedStatement.setArray(i,resultSet.getArray(i)); .... however this throws java.lang.UnsupportedOperationException I have tried several other ways, with no luck. ... preparedStatement.setObject(i,resultSet.getObject(i)); ... throws java.sql.SQLException: ERROR: column "so_slspsn" is of type character varying[] but expression is of type character varying and ... preparedStatement.setObject(i,resultSet.getObject(i),2003); ... throws org.postgresql.util.PSQLException: Unsupported Types value: 2,003 What am i doing wrong? ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly