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

From dmp
Subject Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Date
Msg-id 50CB6094.3000905@ttc-cmc.net
Whole thread Raw
List 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 by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Next
From: Chen Huajun
Date:
Subject: Re: performance problem of Failover Datasource?