You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Larry Meadors <lm...@apache.org> on 2007/03/28 15:40:54 UTC
Re: Multiple select from external xml in a ResultMap problem
Are you using the JDBC-ODBC bridge?
Larry
On 3/28/07, Cihat.altuntas <ci...@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 ...