Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)

From: Haifeng Liu <liuhaifeng(at)live(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Date: 2012-12-13 10:44:56
Message-ID: BLU0-SMTP1143B3C57133A122263A47AB94E0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-jdbc

Hi,

I have a DB writer program written in Java, it do batch updates, and will try to update each record in a batch if it failed. I think no any record in a batch will be update if the batch failed, but weirdly I found a few records update twice(very little amount among all records).

Well, there is less stuff about postgresql jdbc driver. I wanna know if executeBatch really keep all the records in a batch untouched when the batch failed. Any help is appreciate.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bèrto ëd Sèra 2012-12-13 12:39:28 pooler/router?
Previous Message Devrim GÜNDÜZ 2012-12-13 05:35:36 Re: 9.1 Streaming Replication

Browse pgsql-general by date

  From Date Subject
Next Message James Cowell 2012-12-13 12:26:14 Re: Corrupt indexes on slave when using pg_bulkload on master
Previous Message seiliki 2012-12-13 09:31:04 Trouble with PQnotifies()

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2012-12-13 21:01:55 Re: performance problem of Failover Datasource?
Previous Message Chen Huajun 2012-12-13 10:42:10 Re: performance problem of Failover Datasource?