Empty result set with dynamic query and row handler in iBATIS

[richteri]

Hi,

I'm trying to use the queryWithRowHandler method of iBATIS SqlClientTemplate, but the statement
is returning empty ResultSet and the handleRow method of rowHandler
is not called.

The generated statements are returning at least one row if run manually.

iBatis XML:

<select id="queryId" parameterClass="map" remapResults="true"> 
   SELECT  
   <iterate property="fields" conjunction=","> $fields[]$</iterate>, COUNT(1) as pages 
   FROM aTable 
       LEFT JOIN otherTable ON (...) 
       WHERE ... 
   GROUP BY <iterate property="fields" conjunction=","> $fields[]$</iterate> 
</select>

JAVA

DynamicStatModelRowHandler rowHandler = new DynamicStatModelRowHandler(fields); 
getSqlMapClientTemplate().queryWithRowHandler("queryStat", param, rowHandler); 
return rowHandler.getStats();

VERSIONS:
Spring Framework 2.5.6, Ibatis 2.3.4.726, Oracle XE 10g

Any help is much appreciated.

[richteri]

Thanks, putting resultClass="java.util.HashMap" into the opening select tag helped.