pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help me please !
3+ messages / 3 participants
[nested] [flat]

* Help me please !
@ 2005-02-19 11:05  Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Asatryan, Anahit @ 2005-02-19 11:05 UTC (permalink / raw)
  To: pgsql-performance

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.

 

 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Help me please !
@ 2005-02-23 08:29  Richard Huxton <dev@archonet.com>
  parent: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Richard Huxton @ 2005-02-23 08:29 UTC (permalink / raw)
  To: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>; +Cc: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Help me please !
@ 2005-02-23 14:42  Markus Schaber <schabios@logi-track.com>
  parent: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Markus Schaber @ 2005-02-23 14:42 UTC (permalink / raw)
  To: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>; +Cc: pgsql-performance

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

Attachments:

  signature.asc (application/pgp-signature, 255B) download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-02-23 14:42 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-19 11:05 Help me please ! Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
2005-02-23 08:29 ` Richard Huxton <dev@archonet.com>
2005-02-23 14:42 ` Markus Schaber <schabios@logi-track.com>

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