Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 02B009649 for ; Tue, 31 Jul 2012 14:14:26 +0000 (UTC) Received: (qmail 44010 invoked by uid 500); 31 Jul 2012 14:14:25 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 43963 invoked by uid 500); 31 Jul 2012 14:14:25 -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 43956 invoked by uid 99); 31 Jul 2012 14:14:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2012 14:14:25 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of al.eridani@gmail.com designates 209.85.214.172 as permitted sender) Received: from [209.85.214.172] (HELO mail-ob0-f172.google.com) (209.85.214.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2012 14:14:18 +0000 Received: by obbwc20 with SMTP id wc20so12206804obb.31 for ; Tue, 31 Jul 2012 07:13:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=xbKGslEawK4uLYCbQs/tyVgRmlDHjj+qP9/J85TDpts=; b=qC7NHGlQIgoq82sLZghKHirhyhnrImrRV1KgTt7HNsjWKzFbIomJwcDOtVA1PD6VHi XXQP+f/Vn5ui/WotJrvwte/AGmp5fu8CnVDVKKYlkP2wZPnJPt2t4T4OjQn5xQWVqu5K QxWKLzxjEpS8BtL4P/j8QKHLjt1WwUHCArwAAPaM7SN7rvXIwY6EirbjlPkhFalacJbo H+g1GGnyfEGiJHX6KAv5m0jFEof70XUR9ebU8OWx8V5odYNl7g+0xZZb6N95puNQdQ1g 9uVDJWM5SR8tCFnFTe8xkOcCs1U32WC6DDvu3ENYdGZ7lvbnxR6PpbKkKFsafCQBTGzZ Qq9g== MIME-Version: 1.0 Received: by 10.182.164.40 with SMTP id yn8mr23389585obb.40.1343744037007; Tue, 31 Jul 2012 07:13:57 -0700 (PDT) Received: by 10.182.67.38 with HTTP; Tue, 31 Jul 2012 07:13:56 -0700 (PDT) In-Reply-To: <50172655.9030107@gmail.com> References: <50172655.9030107@gmail.com> Date: Tue, 31 Jul 2012 07:13:56 -0700 Message-ID: Subject: Re: Cannot read table while writing transaction in another connection From: Al Eridani To: Derby Discussion Content-Type: text/plain; charset=ISO-8859-1 On Mon, Jul 30, 2012 at 5:27 PM, Bryan Pendleton wrote: > You can try using a lower isolation level: > http://db.apache.org/derby/docs/10.9/devguide/cdevconcepts15366.html > > But that's not exactly the same thing (e.g., at a lower isolation level, > it might be that the count returns the instantaneous count of rows > in the table, including some rows from uncommitted transactions). Thank you, Bryan.