Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 46542 invoked from network); 1 Dec 2005 13:20:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Dec 2005 13:20:03 -0000 Received: (qmail 43754 invoked by uid 500); 1 Dec 2005 13:20:02 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 43720 invoked by uid 500); 1 Dec 2005 13:20:01 -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 43678 invoked by uid 99); 1 Dec 2005 13:20:00 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Dec 2005 05:20:00 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Dec 2005 05:21:26 -0800 Received: from phys-epost-1 ([129.159.136.14]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id jB1DJZ3F014930 for ; Thu, 1 Dec 2005 06:19:35 -0700 (MST) Received: from conversion-daemon.epost-mail1.sweden.sun.com by epost-mail1.sweden.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IQT00301M3JHG@epost-mail1.sweden.sun.com> (original mail from Oystein.Grovlen@Sun.COM) for derby-user@db.apache.org; Thu, 01 Dec 2005 14:19:35 +0100 (MET) Received: from [129.159.112.211] (atum11.Norway.Sun.COM [129.159.112.211]) by epost-mail1.sweden.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTPA id <0IQT0012RMCM1E@epost-mail1.sweden.sun.com> for derby-user@db.apache.org; Thu, 01 Dec 2005 14:19:35 +0100 (MET) Date: Thu, 01 Dec 2005 14:19:34 +0100 From: =?ISO-8859-1?Q?=D8ystein_Gr=F8vlen_-_Sun_Norway?= Subject: Re: TableLock on INSERT In-reply-to: <438EF5DD.3080209@gmail.com> To: Derby Discussion Reply-to: Oystein.Grovlen@Sun.COM Message-id: <438EF866.7040305@sun.com> Organization: Sun Microsystems MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 8BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040618 References: <438EF5DD.3080209@gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Vaide Zuikeviciute wrote: > Hi, > > Do INSERT operations locks all the table in Derby? > Thanks! No, but the rows that are inserted are locked until the transaction commits. -- �ystein