Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TjBIb-0008GJ-02 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Dec 2012 16:06:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TjBIa-00007N-HG for pgsql-admin@arkaria.postgresql.org; Thu, 13 Dec 2012 16:06:12 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TjBIZ-00007F-Q4 for pgsql-admin@postgresql.org; Thu, 13 Dec 2012 16:06:11 +0000 Received: from mailout-us.gmx.com ([74.208.5.67]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TjBIY-0002WL-EX for pgsql-admin@postgresql.org; Thu, 13 Dec 2012 16:06:11 +0000 Received: (qmail 8556 invoked by uid 0); 13 Dec 2012 16:06:09 -0000 Received: from 76.255.19.161 by rms-us001 with HTTP Content-Type: text/plain; charset="utf-8" Date: Thu, 13 Dec 2012 11:06:07 -0500 From: "Kevin Grittner" Message-ID: <20121213160607.80090@gmx.com> MIME-Version: 1.0 Subject: Re: Confuse about the behaveior of PreparedStatement.executeBatch (jdbc) To: "Haifeng Liu" ,pgsql-admin@postgresql.org X-Authenticated: #138763884 X-Flags: 0001 X-Mailer: GMX.com Web Mailer x-registered: 0 Content-Transfer-Encoding: 8bit X-GMX-UID: uJm7cC1+3zOlOQ09Lnwh58l+IGRvb4DA X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Haifeng Liu wrote: > I wanna know if executeBatch really keep all the records in a > batch untouched when the batch failed. I recommend asking on the pgsql-jdbc list. You might want to mention what autoCommit is set to during the attempt. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin