Help with Array

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?

Responses

Browse pgsql-sql by date

  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