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 >
