Re: JDBC executeBatch() hangs without error

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: JDBC executeBatch() hangs without error
Дата
Msg-id alpine.BSO.2.03.1309261345001.26217@ejurka.com
обсуждение исходный текст
Ответ на Re: JDBC executeBatch() hangs without error  (Kevin Wooten <kdubb@me.com>)
Ответы Re: JDBC executeBatch() hangs without error  ("Vinay S (vinas)" <vinas@cisco.com>)
Список pgsql-jdbc

On Thu, 26 Sep 2013, Kevin Wooten wrote:

> Could this be related to the note in QueryExecutorImpl.java ~ line 287
> titled "Deadlock Avoidance"?
> If I remember correctly it's specifically related to batched queries and
> synchronous TCP.

Almost certainly.  The thing to look at is setting the network buffer
sizes to use to large values to avoid the deadlock.  The default values
are machine dependent which also explains it working or not on different
machines.  These are unfortunately not documented, but were introduced in
this commit:

https://github.com/pgjdbc/pgjdbc/commit/4e7f65b91e95d6249c78de6944f09cd34ef1ae87

Kris Jurka


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

Предыдущее
От: Kevin Wooten
Дата:
Сообщение: Re: JDBC executeBatch() hangs without error
Следующее
От: "Vinay S (vinas)"
Дата:
Сообщение: Re: JDBC executeBatch() hangs without error