From derby-user-return-26-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Aug 31 07:45:28 2004 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 23342 invoked from network); 31 Aug 2004 07:45:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 31 Aug 2004 07:45:27 -0000 Received: (qmail 44937 invoked by uid 500); 31 Aug 2004 07:45:26 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 44893 invoked by uid 500); 31 Aug 2004 07:45:25 -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 44870 invoked by uid 99); 31 Aug 2004 07:45:25 -0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=HTML_50_60,HTML_MESSAGE,SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [216.255.223.199] (HELO domain-mail.icehouse.net) (216.255.223.199) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 31 Aug 2004 00:45:25 -0700 Received: from brianxp (c-67-168-36-16.client.comcast.net [67.168.36.16]) by domain-mail.icehouse.net (Postfix) with SMTP id B7F772740B4; Tue, 31 Aug 2004 00:21:06 -0700 (PDT) Message-ID: <000a01c48f2b$15f68660$6501a8c0@brianxp> From: "Brian Abbott" To: Cc: "Derby Development" Subject: PreparedStatement.addBatch/executeBatch issues Date: Tue, 31 Aug 2004 00:21:07 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C48EF0.6912C6F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C48EF0.6912C6F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_0007_01C48EF0.6912C6F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Has anyone had any problems executing=20 addBatch(void) and executeBatch(void) in Derby?

I have a loop that inserts integers = into a two=20 column table. At the bottom of the iteration is a call to addBatch() = once the=20 loop finishes, I call executeBatch(). However I'm missing a great deal = of data.=20 I'm creating the connection with autoCommit set to false and calling=20 Connection.commit() later in the sequence. Any ideas?

Brian

------=_NextPart_000_0007_01C48EF0.6912C6F0--