Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 70992 invoked from network); 21 Mar 2007 17:23:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Mar 2007 17:23:57 -0000 Received: (qmail 49573 invoked by uid 500); 21 Mar 2007 17:24:02 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 49534 invoked by uid 500); 21 Mar 2007 17:24:01 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 49516 invoked by uid 99); 21 Mar 2007 17:24:01 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 10:24:01 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of teds.mailing.lists@gmail.com designates 209.85.132.240 as permitted sender) Received: from [209.85.132.240] (HELO an-out-0708.google.com) (209.85.132.240) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 10:23:51 -0700 Received: by an-out-0708.google.com with SMTP id c10so367711ana for ; Wed, 21 Mar 2007 10:23:30 -0700 (PDT) DKIM-Signature: a=rsa-sha1; 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:content-transfer-encoding:content-disposition:references; b=MGLVWBaCWqKjS3bTuu32FlJHHnun9EBqV9021/6flYUHUoxIVRvdq1k0PyKFEJ9h0Eqe4rSM6uc8xEyx2CneHEOGvFuqbuZd6o7Hk2Mb2Z9jda04mHLgpIa8A4y0JMs0GHVT4SRUjUQpttzhYL2hJ5eb9I5iVRyT69MTUKiM9OU= 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:content-transfer-encoding:content-disposition:references; b=DaCvPMDwu/u1wgv28eID1oqndwXfc8sobySbGXD47SevEiQoDMyKC7qJixnJkLfgK1Wya9lGy0IFC9RuVABvQS8X4p8TiovRHbsmt7OONy5SB3uiS7fROK+NaOZTSkEdKPe8QbvEG5PsAzIrPRUdKYnmYzATDcNhzDm/xbLRoF4= Received: by 10.100.47.6 with SMTP id u6mr760827anu.1174497810292; Wed, 21 Mar 2007 10:23:30 -0700 (PDT) Received: by 10.100.168.16 with HTTP; Wed, 21 Mar 2007 10:23:30 -0700 (PDT) Message-ID: <295494f50703211023k4e429017ledddeba5c16d0ab1@mail.gmail.com> Date: Wed, 21 Mar 2007 13:23:30 -0400 From: "Ted Schrader" To: user-java@ibatis.apache.org Subject: Re: Semi complex mapping question In-Reply-To: <8eed5c5b0703210931q11f6e3edobcb6aafed84495e4@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8eed5c5b0703210220t3b38e433kdd4650e91742f11d@mail.gmail.com> <295494f50703210629p3463cb4fkc1fe526e1a68dce4@mail.gmail.com> <8eed5c5b0703210712v5c27777re0a23d9e474bd505@mail.gmail.com> <295494f50703210855n3859c7cehf8fb60cbf3cc7e72@mail.gmail.com> <8eed5c5b0703210931q11f6e3edobcb6aafed84495e4@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org Hi Mike, I see where you found the composite key syntax in the Developer's Guide ("Composite Keys or Multiple Complex Parameters Properties"). The guide does make it sound like the values are being passed in to the nested select. I've run out of ideas. However, when you get this approach working, this will not avoid N+1 selects from being executed; iBATIS will simply execute them for you with a single invocation of queryForXXXX(). To the list: the guide also gives the impression that the composite key syntax can only be used with nested statements and not with the "groupBy" attribute. Is this true? Thanks, Ted