ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pramodreddy.kampa...@gsa.gov
Subject Result Map - duplicate columns
Date Tue, 22 Jan 2008 16:59:50 GMT
Hi there,

       I  currently use the query (using alias) as:

Select DISTINCT
         A.Key as java1,
         B.Key as java2,
         C.Key as java3 
>From 
          A,B,C

But now for performance issues  when i tried to use result map like this:


<result property="java1" column="Key"/>
<result property="java2" column="Key"/> 
 <result property="java3" column="Key"/> 


Select DISTINCT
         A.Key 
         B.Key 
         C.Key 
>From 
          A,B,C


Doesnot work, there are no errors but i could see the same values 
returning in all the columns.

In another attempt I have tried like this:

               <result property="java1" column="Key" columnIndex ="0"/> 
            <result property="java2" column="Key" columnIndex ="1"/> 
                <result property="java3" column="Key" columnIndex ="2"/>   
 

But doesnot work .. the result is same.

Can any help me fixing this problem...??


Regards,
Pramodreddy Kampalli 


Mime
View raw message