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

From: dmp <danap(at)ttc-cmc(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Date: 2012-12-14 17:23:32
Message-ID: 50CB6094.3000905@ttc-cmc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Chen Huajun 2012-12-15 07:10:49 Re: performance problem of Failover Datasource?
Previous Message Kris Jurka 2012-12-14 16:51:14 Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)