ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kris A. Jenkins" <krisajenk...@yahoo.co.uk>
Subject Re: Indexing POJOs
Date Sun, 13 Feb 2005 21:34:21 GMT
 --- 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