| From: | "Jeremiah Elliott" <geek00(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Help with Array |
| Date: | 2007-01-08 17:24:45 |
| Message-ID: | 17eca7f50701080924h2faa6286yfc9b7758a69a3f0@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aaron Bono | 2007-01-08 18:35:23 | Re: Help with Array |
| Previous Message | Richard Broersma Jr | 2007-01-08 14:49:53 | Re: how un-suscribe from this list |