Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 63667 invoked from network); 31 Aug 2008 16:24:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 31 Aug 2008 16:24:12 -0000 Received: (qmail 74513 invoked by uid 500); 31 Aug 2008 16:24:09 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 74473 invoked by uid 500); 31 Aug 2008 16:24:08 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 74461 invoked by uid 99); 31 Aug 2008 16:24:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 31 Aug 2008 09:24:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=SPF_PASS,WHOIS_NETSOLPR X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dmitri.pissarenko@gmail.com designates 64.233.184.237 as permitted sender) Received: from [64.233.184.237] (HELO wr-out-0506.google.com) (64.233.184.237) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 31 Aug 2008 16:23:08 +0000 Received: by wr-out-0506.google.com with SMTP id 67so1437461wri.3 for ; Sun, 31 Aug 2008 09:23:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=43wCVMEQYk+kzykQM4QINKNulVyLPTjmuOpJF9sUdjU=; b=K12qr3JWQIerIWFfGQSloTmNftsshG/883SlG2S54uUoCpnE1b25WA9B+7VSYrjTcQ T2+bCZltujeCGR+VjUJGcYAFJU+F3pIcMr3s2D0wqfTukdNg1z6ApaQ+4yqc0mN16n3Z 02bpPY0rOuCGY3ZrMtT03u1zgUyiJqwcddZiQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=ce82OUz9MPoZrZBjE5/c/4mhQImYI+JdEUhGBmHTwKLfC1yX+SqfLrkj1H+5VCa33p xgmZvgDDLKx7yLxUy85s/2ldE6M4QmgTFjgxMCgQ5varvnSbSjdITOyM4esC/jZZ+b5a hLxK1lcJilHSX7F+fRgnXdjrpS/hG2tpYJH6I= Received: by 10.90.30.2 with SMTP id d2mr6448320agd.118.1220199801101; Sun, 31 Aug 2008 09:23:21 -0700 (PDT) Received: by 10.90.86.13 with HTTP; Sun, 31 Aug 2008 09:23:21 -0700 (PDT) Message-ID: Date: Sun, 31 Aug 2008 18:23:21 +0200 From: "Dmitri Pissarenko" To: "Derby Discussion" Subject: Re: Maximum amount of data suitable for Derby In-Reply-To: <48B82383.5070100@sun.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200808291400.09829.k.huwig@iku-ag.de> <48B82383.5070100@sun.com> X-Virus-Checked: Checked by ClamAV on apache.org Hello! Thanks for your answer On Fri, Aug 29, 2008 at 6:27 PM, Rick Hillegas wrote: > Hi Dmitri, > > If you are bulk-loading this data, then the following may help > > 1) You can use JDBC statement batching. Please see the javadoc for > Statement.addBatch(), PreparedStatement.addBatch() and > Statement.executeBatch() as well as this link: > http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec2/jdbc2.1.frame6.html Imagine I have added 10 statements to PreparedStatement instance. Now I execute executeBatch, and during execution of statement 5 a BatchUpdateException occurs. Does Derby try to execute the remaining statements, after an error has occurred? Thanks in advance Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko