Hi,
I have sqlMap:
<?xml version='1.0' encoding='windows-1251'?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd";>
<sqlMap namespace="elementInGost">
<typeAlias alias="ElementInGost" type="nkmk.ibatis.domain.ElementInGost"/>
<typeAlias alias="Interval" type="nkmk.ibatis.domain.Interval"/>
<resultMap id="ElementWithIntervals" class="ElementInGost">
<result column="id_elem" property="elementId"/>
<result column="sname" property="shortName"/>
<result column="lname" property="longName"/>
<result column="id_gost" property="gostId"/>
<result column="{gostId=id_gost, elementId=id_elem}"
property="intervalList" select="elementInGost.getIntervalsOfElement"/>
</resultMap>
<statement id="searchElementInGost" parameterClass="ElementInGost"
resultMap="elementInGost.ElementWithIntervals">
select distinct t1.id_elem,
t1.id_gost,
t2.sname,
t2.lname
from sp_gost_detail t1, sp_name_nsi t2
where t2.id = t1.id_elem
and t1.id_elem=#elementId#
and t1.id_gost=#gostId#
</statement>
<statement id="getIntervalsOfElement" resultClass="Interval">
select t2.id intervalId,
t1.kf kf,
t2.conc_ot concOt,
t2.conc_do concDo
from sp_gost_detail t1, sp_interval t2
where t2.id=t1.id_interval(+)
and t1.id_elem(+)=#elementId#
and t1.id_gost(+)=#gostId#
order by t2.id
</statement>
</sqlMap>
ElementInGostSqlMapDao:
....
public ElementInGost getElementById(int gostId, int elementId)
{
ElementInGost elem = new ElementInGost();
elem.setGostId(new Integer(gostId));
elem.setElementId(new Integer(elementId));
return (ElementInGost) queryForObject("elementInGost.searchElementInGost",
elem);
}
...
Then I have Element object and call element.getIntervalList(), which
return List using "getIntervalsOfElement" from sqlMap file. And
this List is always order by kf field. Why? I change "order by
t2.id" to, for example, "order by t1.kf desc" but there's no changes.
Why??
--
Thanks.
mailto:[EMAIL PROTECTED]
