Return-Path: X-Original-To: apmail-cayenne-user-archive@www.apache.org Delivered-To: apmail-cayenne-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 3668C9DE5 for ; Mon, 2 Apr 2012 08:53:36 +0000 (UTC) Received: (qmail 96321 invoked by uid 500); 2 Apr 2012 08:53:35 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 96298 invoked by uid 500); 2 Apr 2012 08:53:35 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 96273 invoked by uid 99); 2 Apr 2012 08:53:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2012 08:53:34 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [60.234.4.74] (HELO nctlincom01.orcon.net.nz) (60.234.4.74) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Apr 2012 08:53:26 +0000 Received: from mx5.orcon.net.nz (mx5.orcon.net.nz [219.88.242.55]) by nctlincom01.orcon.net.nz (8.14.3/8.14.3/Debian-9.4) with ESMTP id q328qQ6M005540 for ; Mon, 2 Apr 2012 20:52:26 +1200 Received: from Debian-exim by mx5.orcon.net.nz with local (Exim 4.69) (envelope-from ) id 1SEd0W-0000i9-Hl for user@cayenne.apache.org; Mon, 02 Apr 2012 20:53:00 +1200 Received: from [121.98.190.242] (helo=matai.local) by mx5.orcon.net.nz with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1SEd0W-0000hh-Cy for user@cayenne.apache.org; Mon, 02 Apr 2012 20:53:00 +1200 Message-ID: <4F7968EB.6030404@lindesay.co.nz> Date: Mon, 02 Apr 2012 20:52:59 +1200 From: Andrew Lindesay User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:11.0) Gecko/20120327 Thunderbird/11.0.1 MIME-Version: 1.0 To: user@cayenne.apache.org Subject: Re: lazy loading (slightly OT but still pretty important) References: <6A04989A-8B34-453F-B3FB-7921F952C525@roxanemy.com> <339E993B-3E59-474E-9575-F183632A4916@earthlink.net> <71304D3C-1500-43A5-A9AD-7F6F3C0B7F34@earthlink.net> <98378B75-ABB3-4659-A074-BCE326F4192A@earthlink.net> <1333354727000-3877037.post@n3.nabble.com> In-Reply-To: <1333354727000-3877037.post@n3.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-DSPAM-Check: by mx5.orcon.net.nz on Mon, 02 Apr 2012 20:53:00 +1200 X-DSPAM-Result: Whitelisted X-DSPAM-Processed: Mon Apr 2 20:53:00 2012 X-DSPAM-Confidence: 0.6962 X-DSPAM-Probability: 0.0000 X-Bayes-Prob: 0.0001 (Score 0, tokens from: @@RPTN, default) X-Spam-Score: 0.00 () [Hold at 5.00] X-CanIt-Geo: ip=121.98.190.242; country=NZ; region=E7; city=Auckland; latitude=-36.8667; longitude=174.7667; http://maps.google.com/maps?q=-36.8667,174.7667&z=6 X-CanItPRO-Stream: base:default X-Canit-Stats-ID: 06GQUQqj8 - 04d2a74e3601 - 20120402 X-Scanned-By: CanIt (www . roaringpenguin . com) on 172.16.100.174 Hi Sheldon; You can just create an EJBQLQuery that extracts those specific columns (expressed as entity attributes' names) and then run the query and you'll pull back that data. A crude example of such a query; "SELECT o." + Foo.CODE_PROPERTY+" FROM "+Foo.class.getSimpleName()+" o WHERE o."...... Is that what you mean? Regards; On 2/04/12 8:18 PM, Sheldon wrote: > What I mean is, > > if I have a Table with n columns (col1, col2, col3 ...) and want load only > the value of col1 and col3 (without loading col2 and the others). > Is this example possible? > > Sheldon > > -- > View this message in context: http://cayenne.195.n3.nabble.com/lazy-loading-tp3863908p3877037.html > Sent from the Cayenne - User mailing list archive at Nabble.com. > -- Andrew Lindesay www.silvereye.co.nz