ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Colin Williams <colinwilliams...@gmail.com>
Subject Re: Indexing POJOs
Date Sun, 13 Feb 2005 22:24:50 GMT
Kris,
thanks for that,
so in theory i should be able to say

<result property="id.account" column="ACCOUNT" />
<result property="id.branch" column="BRANCH" />

ill let you know if that works


On Sun, 13 Feb 2005 21:34:21 +0000 (GMT), Kris A. Jenkins
<krisajenkins@yahoo.co.uk> wrote:
> --- Colin Williams <colinwilliams007@gmail.com>
> wrote:
> > Is there a way to index my POJOs without running
> > another SQL statement
> > similar to the way it is done in Hibernate?
> > eg
> >
> > All my POJOs have an object that acts as the key for
> > the object, called id
> >
> > currently I generate this in Ibatis by defining
> > another SQL statement
> > to retrieve the id field
> >
> >
> > <resultMap id="getCustomerResult" class="customer">
> >       <result property="id"
> > column="{account=ACCOUNT,branch=BRANCH}"
> > select="getCustomerId"/>
> >       <result property="email" column="email"/>
> > </resultMap>
> >
> > but this also means that for every record I retrieve
> > from the relevant
> > file i must run another SQL statement to generate
> > the id.
> >
> > Is there any way in Ibatis to do this without
> > running another SQL Statement
> > eg in Hibernate
> >               <composite-id name="id" class="CustomerKey">
> >                 <key-property name="account" type="long"
> > column="ACCOUNT"/>
> >                 <key-property name="branch" type="long"
> > column="BRANCH"/>
> >               </composite-id>
> >
> > will take the values from the fields ACCOUNT and
> > BRANCH and use them
> > to construct a CustomerKey object
> 
> Colin,
> 
> Have you had a look in the developer's guide under the
> heading, "Avoiding N+1 Selects (1:1)"?  I think you
> can use the same recipe to solve your problem...
> 
> HTH,
> Kris
> 
> 
> ___________________________________________________________
> ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
>

Mime
View raw message