Re: CopyManager.copyOut stuck in socket read

Поиск
Список
Период
Сортировка
От Sehrope Sarkuni
Тема Re: CopyManager.copyOut stuck in socket read
Дата
Msg-id CAH7T-aoTjLs9C3=4x+cEtHOK+9CB_8A-oJdinQmczc7z2bMnuQ@mail.gmail.com
обсуждение исходный текст
Ответ на CopyManager.copyOut stuck in socket read  (Karthik Shivashankar <kshivashank@sandvine.com>)
Ответы RE: CopyManager.copyOut stuck in socket read
Список pgsql-jdbc
On Wed, May 20, 2020 at 3:34 AM Karthik Shivashankar <kshivashank@sandvine.com> wrote:

We are using a java application that does something like “COPY (select xyz from abc ) TO filename.csv.gz” using JDBC to postgres 9.3.11 server.


A COPY command which outputs to a server file must be executed as a regular query, not as a COPY statement. Use a regular JDBC java.sql.Statement, not the PGJDBC driver specific CopyManager classes.

The PGJDBC specific CopyManager classes are for COPY operations that read "... FROM STDIN" or write "... TO STDOUT".

I'm not sure exactly what's causing it to hang but I bet it's waiting for COPY related messages from the server that are never arriving because the executed command is not returning a COPY stream.

Regards,
-- Sehrope Sarkuni
Founder & CEO | JackDB, Inc. | https://www.jackdb.com/
 

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Karthik Shivashankar
Дата:
Сообщение: CopyManager.copyOut stuck in socket read
Следующее
От: Karthik Shivashankar
Дата:
Сообщение: RE: CopyManager.copyOut stuck in socket read