statement from another mapped file

[Dorin Manoli]

Hi guys, how can I call a mapped statement from another mapped file.

I want to do  like here :

<resultMap id="select-category-result" class="Category">

<result property="Id" column="CAT_ID"/>

<result property="Description" column="CAT_DESCRIPTION"/>

<result property="ProductList" column="CAT_ID" select="selectProductsByCatId"/>

</resultMap>

<resultMap id="select-product-result" class="Product">

<result property="Id" column="PRD_ID"/>

<result property="Description" column="PRD_DESCRIPTION"/>

</resultMap>

<resultMaps>

<statements>

<!-- This statement executes 1 time -->

<statement id="selectCategory" parameterClass="int" 
resultMap="select-category-result">

select * from CATEGORY where CAT_ID = #value#

</statement>

 

 

Exept that selectProductsByCatId statement will be in another file.

At the moment I got an exception