ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michal Malecki" <misie...@poczta.onet.pl>
Subject Re: queryForList with skip max and groupBy feature
Date Thu, 04 Aug 2005 13:33:38 GMT
part of sql is:
select ls_name,le_id,le_level,le_message,le_location,le_logger,
from log_sources, log_events
LEFT OUTER JOIN log_event_attributes on (lea_event = le_id)
LEFT OUTER JOIN log_keys ON (lk_id = lea_key)
where ls_id = le_source
First I had Limit #limit# Offset #offset# at the end of sql,
now I have
List result = session.queryForList("selectEvents", new ListHolder(
     conditions, limit, offset), offset,
     limit );
in the code
limit and offset from ListHolder is not used
lk_name,lea_value in the sql is used to create list of KeyValue objects

Michal Malecki
----- Original Message ----- 
From: "James, Steven" <Steven.James@logicacmg.com>
To: <user-java@ibatis.apache.org>
Sent: Thursday, August 04, 2005 3:24 PM
Subject: RE: queryForList with skip max and groupBy feature

i meant number of objects returned... Caqn u also post the sql..



From: Michal Malecki [mailto:misiek_x@poczta.onet.pl]
Sent: Thu 04/08/2005 14:15
To: user-java@ibatis.apache.org
Subject: Re: queryForList with skip max and groupBy feature

as far as i am aware there is no such feature so send some more details ie
the xml file with query?

About which feature are you talking about?
<resultMap class="LoggingBean" id="LoggingBeansMap" groupBy="id">
<result property="id" column="le_id"/>
<result property="level" column="le_level"/>
<result property="location" column="le_location"/>
<result property="logger" column="le_logger"/>
<result property="timestamp" column="le_timestamp" jdbcType="TIMESTAMP"
<result property="mdc" resultMap="KeyValueMap"/>

<resultMap class="KeyValue" id="KeyValueMap">
<result property="key" column="lk_name"/>
<result property="value" column="lea_value"/>

Michal Malecki
Dzial Uslug Sieciowych

This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender. Thank you.

View raw message