Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 44517 invoked from network); 6 Sep 2007 20:34:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Sep 2007 20:34:56 -0000 Received: (qmail 75617 invoked by uid 500); 6 Sep 2007 20:34:50 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 75584 invoked by uid 500); 6 Sep 2007 20:34:50 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 75575 invoked by uid 99); 6 Sep 2007 20:34:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Sep 2007 13:34:50 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of catalina.wei@gmail.com designates 66.249.82.230 as permitted sender) Received: from [66.249.82.230] (HELO wx-out-0506.google.com) (66.249.82.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Sep 2007 20:34:47 +0000 Received: by wx-out-0506.google.com with SMTP id s7so233781wxc for ; Thu, 06 Sep 2007 13:34:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=I4BgNwTH9OnK3xNxcT0R/R+NDz8ASmuotb843U77yCc=; b=f67sGR1A2Josu9ZoABhqyIS+3WDiT5JDhXFonRxIEzhgIodQC+wh7xMCcCY3GrYyB2dvKxGyGfnf+aBx0XDueDSH23kWsNqnwIygIILUAX3gxmbEvRW6ay83tdZRd0Djd4U+030WsrU1vC3V6p01F8uluZ5bi9xED9BlCimDdj4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Lc57JJWksIwx2DjdXEv6Vm6yp5U8L/01QsDlX3ZexSrEF/z4BAtjkaFbtogxjG5gtTDItG8sP1iNX0or6FYq0H7yGpqXswXl7F5VVWJ5OBdbgsUG9/JKXDUWfRf3z5y/yjTied8U/vvny6YcD0rMEOpheWbir6chQE2mCLla92A= Received: by 10.90.81.14 with SMTP id e14mr1959947agb.1189110866253; Thu, 06 Sep 2007 13:34:26 -0700 (PDT) Received: by 10.35.119.14 with HTTP; Thu, 6 Sep 2007 13:34:26 -0700 (PDT) Message-ID: Date: Thu, 6 Sep 2007 13:34:26 -0700 From: "catalina wei" To: dev@openjpa.apache.org Subject: Re: DB2 and "FOR UPDATE OF" clause In-Reply-To: <7262f25e0709061328r221c4eaav9fa0aaa2750a2c97@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_76397_2762657.1189110866181" References: <7262f25e0709061328r221c4eaav9fa0aaa2750a2c97@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_76397_2762657.1189110866181 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Patrick, what version of DB2 are you running ? Catalina On 9/6/07, Patrick Linskey wrote: > > Hi, > > I'm seeing SQL like so: > > SELECT t0.ID, t0.VERSN, t0.STRINGFIELD FROM SIMPLEPERSISTENTCLASS t0 > FOR UPDATE OF > > Is this valid DB2 SQL? I'm using a DB2 database that returns SQL08016 > from a call to getDatabaseProductVersion(). I'm guessing that the > checks for the FOR UPDATE clauses are getting tripped up somewhere. > Any suggestions about what it should be for this version of DB2? > > -Patrick > > -- > Patrick Linskey > 202 669 5907 > ------=_Part_76397_2762657.1189110866181--