Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 65233 invoked from network); 7 Apr 2011 22:11:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Apr 2011 22:11:25 -0000 Received: (qmail 71354 invoked by uid 500); 7 Apr 2011 22:11:24 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 71253 invoked by uid 500); 7 Apr 2011 22:11:24 -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 71246 invoked by uid 99); 7 Apr 2011 22:11:24 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Apr 2011 22:11:24 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [148.87.113.121] (HELO rcsinet10.oracle.com) (148.87.113.121) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Apr 2011 22:11:15 +0000 Received: from rcsinet13.oracle.com (rcsinet13.oracle.com [148.87.113.125]) by rcsinet10.oracle.com (Switch-3.4.2/Switch-3.4.2) with ESMTP id p37MAq77025059 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Thu, 7 Apr 2011 22:10:53 GMT Received: from acsmt357.oracle.com (acsmt357.oracle.com [141.146.40.157]) by rcsinet13.oracle.com (Switch-3.4.2/Switch-3.4.1) with ESMTP id p37MApvP005371 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 7 Apr 2011 22:10:52 GMT Received: from abhmt003.oracle.com (abhmt003.oracle.com [141.146.116.12]) by acsmt357.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id p37MApJ0032118 for ; Thu, 7 Apr 2011 17:10:51 -0500 Received: from localhost (/10.175.23.125) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Thu, 07 Apr 2011 15:10:50 -0700 From: dag.wanvik@oracle.com (Dag H. Wanvik) To: "Derby Discussion" Subject: Re: funny behavior References: <4D974A36.5030100@gmail.com> <0773A3CE9DAC7B42B8F564C52805678D036E1EAE@EVS01.intern.interpay.nl> Date: Fri, 08 Apr 2011 00:10:49 +0200 In-Reply-To: <0773A3CE9DAC7B42B8F564C52805678D036E1EAE@EVS01.intern.interpay.nl> (Malte Kempff's message of "Thu, 7 Apr 2011 18:18:06 +0200") Message-ID: User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/23.1 (usg-unix-v) MIME-Version: 1.0 Content-Type: text/plain X-Source-IP: acsmt357.oracle.com [141.146.40.157] X-Auth-Type: Internal IP X-CT-RefId: str=0001.0A090201.4D9E366C.0085:SCFSTAT5015188,ss=1,fgs=0 X-Virus-Checked: Checked by ClamAV on apache.org writes: > way I use my program it is just executing a select statement. But now > there is the funny thing: derby puts out 25001 error. Obviously it > wants a commit for this select statement... is it because I also > defined those other prepared statements or does derby want a commit > generally even though it is just a select? Reads also set locks to implement the transactional guarantees of SQL (read locks), so this is normal (unless you use READ UNCOMMITTED mode). Dag