From users-return-1488-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org Thu Jan 24 15:39:04 2008 Return-Path: Delivered-To: apmail-openjpa-users-archive@locus.apache.org Received: (qmail 23205 invoked from network); 24 Jan 2008 15:39:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 24 Jan 2008 15:39:04 -0000 Received: (qmail 8027 invoked by uid 500); 24 Jan 2008 15:38:55 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 8004 invoked by uid 500); 24 Jan 2008 15:38:54 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 7995 invoked by uid 99); 24 Jan 2008 15:38:54 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jan 2008 07:38:54 -0800 X-ASF-Spam-Status: No, hits=-2.0 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jmelch@us.ibm.com designates 32.97.110.151 as permitted sender) Received: from [32.97.110.151] (HELO e33.co.us.ibm.com) (32.97.110.151) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jan 2008 15:38:27 +0000 Received: from d03relay02.boulder.ibm.com (d03relay02.boulder.ibm.com [9.17.195.227]) by e33.co.us.ibm.com (8.13.8/8.13.8) with ESMTP id m0OFcUu3017718 for ; Thu, 24 Jan 2008 10:38:30 -0500 Received: from d03av03.boulder.ibm.com (d03av03.boulder.ibm.com [9.17.195.169]) by d03relay02.boulder.ibm.com (8.13.8/8.13.8/NCO v8.7) with ESMTP id m0OFcUVL105164 for ; Thu, 24 Jan 2008 08:38:30 -0700 Received: from d03av03.boulder.ibm.com (loopback [127.0.0.1]) by d03av03.boulder.ibm.com (8.12.11.20060308/8.13.3) with ESMTP id m0OFcUcr013532 for ; Thu, 24 Jan 2008 08:38:30 -0700 Received: from d03nm690.boulder.ibm.com (d03nm690.boulder.ibm.com [9.17.195.59]) by d03av03.boulder.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id m0OFcTu5013511 for ; Thu, 24 Jan 2008 08:38:29 -0700 In-Reply-To: <47988dfa.140.47e1.1773365269@webmailh3.aruba.it> References: <47988dfa.140.47e1.1773365269@webmailh3.aruba.it> To: users@openjpa.apache.org MIME-Version: 1.0 Subject: Help selecting version column X-Mailer: Lotus Notes Release 8.0 August 02, 2007 Message-ID: From: Jeff Melching Date: Thu, 24 Jan 2008 09:38:25 -0600 X-MIMETrack: Serialize by Router on D03NM690/03/M/IBM(Release 7.0.2FP2HF300 | September 14, 2007) at 01/24/2008 08:38:29, Serialize complete at 01/24/2008 08:38:29 Content-Type: multipart/alternative; boundary="=_alternative 0055ADEB862573DA_=" X-Virus-Checked: Checked by ClamAV on apache.org --=_alternative 0055ADEB862573DA_= Content-Type: text/plain; charset="US-ASCII" I am trying to select only the version column of an entity to see if it was changed. If I run the following JPQL where verId is the version field of my entity: select a.verId from AnEntity a where a.id = ?1; The generated sql is: SELECT FROM AN_ENTITY t0 WHERE t0.ID = ? Obviously, this is invalid sql syntax as the columns to select are missing. I am using a DB2 dictionary. --=_alternative 0055ADEB862573DA_=--