ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Bennett <mark.bennett.m...@gmail.com>
Subject Re: grougBy issue
Date Thu, 12 Jan 2006 21:26:55 GMT
Is your "parameters" property in in sessionCommon a List?  (just a guess)

Mark

On 1/12/06, Chen, Tim <Tim.Chen@nielsenmedia.com> wrote:
>
> Version of ibatis?
> Namespace of CommonSession does not exist?
> Mispackaging?
> So many possible reasons
>
> -----Original Message-----
> From: Tony Qian [mailto:daqiqian2@aol.com]
> Sent: Thursday, January 12, 2006 11:25 AM
> To: user-java@ibatis.apache.org
> Subject: Re: grougBy issue
>
> Ok, I found where the problem is. But I don't know why and how to solve
> it.
> resultMap="CommonSession.elementMap" is never got called so that
> parameters is always null.
>
> does anyone know why?
>
> Thanks,
> tony
>
> Tony Qian wrote on 1/11/2006, 1:32 PM:
>
> > All,
> >
> > I know this has been posted before. I have read a number of archived
> > emails regarding this issue and also the example by Clinton. I just  >
> cannot make it work. The property parameters is always null. (btw, i  >
> made it work using sub-select strategy). I just want to improve the  >
> performance. Here is my mapping:
> >
> > <resultMap id="select-sessionCommon" class="sessionCommon"
> > groupBy="brandId">
> >       <result property="brandId" column="brand_id" />
> >       <result property="parameters"
> > resultMap="CommonSession.elementMap" />
> >    </resultMap>
> >
> >    <resultMap id="elementMap" class="element">
> >       <result property="value" column="paramete_value" />
> >       <result property="parameter"
> > resultMap="CommonSession.parameterMap" />
> >    </resultMap>
> >
> >    <resultMap id="parameterMap" class="parameter" >
> >       <result property="parameterId" column="parameter_id" />
> >       <result property="name" column="parameter_name" />
> >       <result property="description" column="description" />
> >    </resultMap>
> >
> >    <select id="selectCommonSession" parameterClass="string"
> > resultMap="select-sessionCommon" >
> >       SELECT distinct
> >        SP.parameter_id,
> >        SP.parameter_name,
> >        SP.description,
> >        SC.parameter_value ,
> >        SC.brand_id
> >        FROM SESSION_INFO_COMMON as SC, SESSION_PARAMETER as SP where
> >                          SP.parameter_id= SC.parameter_id and
> > SC.brand_id=#brandId#  group by SP.parameter_id,SP.parameter_name,
> > SP.description, SC.brand_id ;
> >    </select>
> >
> >
> > please let me know what i did wrong.
> >
> >
> > Appreciate your help,
> > Tony
> >
>
>
>
>

Mime
View raw message