Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 27098 invoked from network); 31 Aug 2004 20:43:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 31 Aug 2004 20:43:56 -0000 Received: (qmail 4011 invoked by uid 500); 31 Aug 2004 20:43:43 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 3824 invoked by uid 500); 31 Aug 2004 20:43:42 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: "Derby Discussion" Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 3800 invoked by uid 99); 31 Aug 2004 20:43:42 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=FORGED_RCVD_HELO,HTML_30_40,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from [32.97.182.106] (HELO e6.ny.us.ibm.com) (32.97.182.106) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 31 Aug 2004 13:43:40 -0700 Received: from northrelay02.pok.ibm.com (northrelay02.pok.ibm.com [9.56.224.150]) by e6.ny.us.ibm.com (8.12.10/8.12.9) with ESMTP id i7VKhXnt313102 for ; Tue, 31 Aug 2004 16:43:38 -0400 Received: from Remulak.Net (d01av02.pok.ibm.com [9.56.224.216]) by northrelay02.pok.ibm.com (8.12.10/NCO/VER6.6) with ESMTP id i7VKiaCb056914 for ; Tue, 31 Aug 2004 16:44:45 -0400 Message-ID: <4134E177.D3F9886A@Remulak.Net> Date: Tue, 31 Aug 2004 13:37:11 -0700 From: Mamtap X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Derby Discussion Subject: Re: PreparedStatement.addBatch/executeBatch issues References: <000a01c48f2b$15f68660$6501a8c0@brianxp> Content-Type: multipart/alternative; boundary="------------A499BDC864255B99AFA153DC" X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N --------------A499BDC864255B99AFA153DC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Brian, Can you provide some specific code for the problem? I am not aware of any existing bug in the Batch functionality. Mamta Brian Abbott wrote: > Has anyone had any problems executing addBatch(void) and > executeBatch(void) in Derby? I have a loop that inserts integers into > a two column table. At the bottom of the iteration is a call to > addBatch() once the loop finishes, I call executeBatch(). However I'm > missing a great deal of data. I'm creating the connection with > autoCommit set to false and calling Connection.commit() later in the > sequence. Any ideas? Brian --------------A499BDC864255B99AFA153DC Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Brian,

Can you provide some specific code for the problem? I am not aware of any existing bug in the Batch functionality.

Mamta

Brian Abbott wrote:

Has anyone had any problems executing addBatch(void) and executeBatch(void) in Derby? I have a loop that inserts integers into a two column table. At the bottom of the iteration is a call to addBatch() once the loop finishes, I call executeBatch(). However I'm missing a great deal of data. I'm creating the connection with autoCommit set to false and calling Connection.commit() later in the sequence. Any ideas? Brian
--------------A499BDC864255B99AFA153DC--