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>
|