Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)

Поиск
Список
Период
Сортировка
От dmp
Тема Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Дата
Msg-id 50CB6094.3000905@ttc-cmc.net
обсуждение исходный текст
Список pgsql-jdbc
Kris Jurka Wrote:
> Internally the driver splits each batch into sub-batches of 250 to send to
> the server to reduce the possibility of deadlocking the network
> connection.  When auto-commit is enabled in the driver, the auto-commit
> setting affects the whole sub-batch of 250 because of how the
> frontend/backend protocol works.  So you are seeing some oddities because
> of some implementation details and you should not use auto-commit with
> batch statements.
>
> Kris Jurka

Direct knowledge and experience to the rescue. Thank you Kris for staying
within ear shot.

danap.


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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Следующее
От: Chen Huajun
Дата:
Сообщение: Re: performance problem of Failover Datasource?