Thanks
for quick reply Marc, I have set parameterClass="Item" but no change, still no
results returned...
Matt
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 03 November 2006 11:36
To: [email protected]
Subject: Re: Ibatis not returning any results
Looks like the parameterClass option is missing in the select.
Cheers
Marc
"Rutherford, Matthew [CIB-IT]" <[EMAIL PROTECTED]> schrieb am 03.11.2006 12:15:14:
> Hi I am using Ibatis SQL Maps 2.1.7
>
> Currently I have the following query in my SqlMapItemDao:
>
> getSqlMapClientTemplate().queryForList("getLatestItemByFii", item);
>
> The sql map looks like:
>
> <resultMap id="result" class="Item">
> <result property="Id" column="id" columnIndex="1"/>
> <result property="currencyCode" column="currency_code" columnIndex="2"/>
> <result property="fii" column="fii" columnIndex="3"/>
> <result property="positionAsAt" column="position_as_at"
> columnIndex="4"/>
> <result property="pos" column="pos" columnIndex="5"/>
> </resultMap>
>
> <select id="getLatestPositionByFii" resultMap="result">
> SELECT id,currency_code,fii, to_char(max(position_as_at)), pos
> FROM item
> WHERE fii = #fii# and pos != 0
> GROUP BY id,currency_code,fii,pos
> </select>
>
> with sql debugging turned on, there is no error msg returned.
>
> If I try the same query in my sql client app I get 1 row of data
> back. But the queryForList() returns nothing to me, and I logged
> the item object's variables to make sure it was the same parameter.
> It is. Why is the List not being populated with the same data?
>
> Thanks for any insight,
> Matt
