| I have a class with composite id , and mapping is 
 <composite-id name="id" class="persistent.activity.InteractionP$Id" access="field" >
 <key-property name="accountId" column="ACCOUNT_ID" />
 <key-property name="contactDate" column="CONTACT_DATE"/>
 <key-property name="contactSeq" column="CONTACT_SEQ" />
 <key-property name="page" column="PAGE" />
 </composite-id>
 
 i am executing sql to return a result set. how should i map in <sql-query> for composite-id ? following doesn't work
 
 <sql-query name="searchInteractions" callable="true">
 <return alias="inter" persistent.activity.InteractionP">
 <return-property name="id">
 <return-column name="ACCOUNT_ID"/>
 <return-column name="CONTACT_DATE"/>
 <return-column name="CONTACT_SEQ"/>
 <return-column name="PAGE"/>
 </return-property>
 <return-property name="summary" column="summary"/>
 </return>
 { ? = call Searcher1.SearchInteractions(?,?) }
 </sql-query>
 
 
 |