Thread: Help me please !

Help me please !

From
"Asatryan, Anahit"
Date:

I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY FROM STDIN function from Java application, but it doesn’t work, it throws:

“org.postgresql.util.PSQLException: Unknown Response Type G”  error.

Please help me!

Note: COPY FROM filename works properly.

 

 

Re: Help me please !

From
Richard Huxton
Date:
Asatryan, Anahit wrote:
> I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY
> FROM STDIN function from Java application, but it doesn't work, it
> throws:
>
> "org.postgresql.util.PSQLException: Unknown Response Type G"  error.

I don't think that there is a "STDIN" if you are executing via JDBC. The
only workaround I know of is to create a file and copy from that, which
you already have working.

--
   Richard Huxton
   Archonet Ltd

Re: Help me please !

From
Markus Schaber
Date:
Hi, Asatryan,

Asatryan, Anahit schrieb:
> I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY
> FROM STDIN function from Java application, but it doesn’t work, it throws:
>
> “org.postgresql.util.PSQLException: Unknown Response Type G”  error.

Currently, there is no COPY support in the postgresql jdbc driver. There
were some patches enabling COPY support floating around on the
pgsql-jdbc@postgresql.org mailing list. You can search the archive and
try whether one of them fits your needs.

AFAIR, COPY support is on the TODO list, but they wait for some other
driver reworking to be finished.

You can discuss this issue on psql-jdbc list or search the archives if
you need more info.


Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com


Attachment