From: Jeremiah Elliott <geek00@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Help with Array
Date: Mon, 8 Jan 2007 11:24:45 -0600
Message-ID: <17eca7f50701080924h2faa6286yfc9b7758a69a3f0@mail.gmail.com> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: geek00@gmail.com
Subject: Re: Help with Array
In-Reply-To: <17eca7f50701080924h2faa6286yfc9b7758a69a3f0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox