Hi Cihat,
Is the namespace correct for the sqlmap where you are looking for your statement ?
Thanks
Utkarsh

--<result property="service" column="serviceCode" select="Service.getService"/>

On 3/28/07, Cihat.altuntas < cihat.altuntas@erenetyazilim.com> wrote:

Hello everyone. Could you help me about this problem.I have complex bean like this


class Line{
   private Stop firstStop;
   private Service service;
   //getter setter.........
}

class Stop{
    private String a;
    private String b;
   //.....
}

class Service{
    private String a;
    private String b;
   //.....
}

I have a resultMap like fallowing

<sqlMap namespace="Line">

        <resultMap id="get-completeLine" class="line">
        <result property="lineCode" column="sLineCode"/>

        <result property="firstStop" column="firstStopCode" select="Stop.getStop"/>
        <result property="service" column="serviceCode" select="Service.getService"/>
        <result property "lineLength" column="nHatUzunlugu"/>
...........................
            </resultMap>
</sqlMap>

When I run this SqlMap error message like this

 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another hstmt.

I am looking forward your answers.

There is no problem if I use only one select in this ResultMap like this

<sqlMap namespace="Line">

        <resultMap id="get-completeLine" class="line">
        <result property="lineCode" column="sHatKodu"/>

        <result property="firstStop" column="firstStopCode" select="Stop.getStop"/>
        //Deleted select for other property bean and it works
        <result property "lineLength" column="nHatUzunlugu"/>
...........................
            </resultMap>
</sqlMap>

it works correctly now. What is the problem. I would be so pleased if someone could help me.
Thanks ...