Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 91011 invoked from network); 18 May 2007 04:51:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 May 2007 04:51:56 -0000 Received: (qmail 38392 invoked by uid 500); 18 May 2007 04:52:02 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 38365 invoked by uid 500); 18 May 2007 04:52:02 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 38356 invoked by uid 99); 18 May 2007 04:52:02 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2007 21:52:02 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2007 21:51:55 -0700 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1HouRC-0006MU-U6 for derby-dev@db.apache.org; Thu, 17 May 2007 21:51:34 -0700 Message-ID: <10676514.post@talk.nabble.com> Date: Thu, 17 May 2007 21:51:34 -0700 (PDT) From: Umakanth Srinivasan To: derby-dev@db.apache.org Subject: Re: Row level locking In-Reply-To: <464CF471.6090308@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: kanth@dhyanit.com References: <10550668.post@talk.nabble.com> <464CF471.6090308@gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org No Iam not performing anything with respect to AutoCommit. I observed that this problem is related to the isolation level. In MySQL the problem did not occur. When I checked the default isolation level of MySQL it is REPEATABLE_READ, in Derby it is READ_COMMITED. Hope I must have the AUTOCOMMIT set to on. -- View this message in context: http://www.nabble.com/Row-level-locking-tf3745257.html#a10676514 Sent from the Apache Derby Developers mailing list archive at Nabble.com.