ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rutherford, Matthew [CIB-IT]" <matthew.rutherf...@citigroup.com>
Subject RE: Ibatis not returning any results
Date Fri, 03 Nov 2006 14:52:23 GMT
No change Graeme, still no items returned (should be 1 row returned for a fii value of 2)

-----Original Message-----
From: Graeme J Sweeney [mailto:ibatis.user@gjsweeney.com]
Sent: 03 November 2006 14:45
To: iBatis List
Subject: RE: Ibatis not returning any results


On Fri, 3 Nov 2006, Rutherford, Matthew [CIB-IT] wrote:

> The java property is of type int.  ie. setFii(2) sets it to an int value 2.  In the db
it is an oracle number(12).
>
> If I do a getItems (select *) type query The list is populated fine.
>
> Any ideas?

what happens if you hardcode the value of fii ?

<select id="getLatestPositionByFii" resultMap="result">
     SELECT id,currency_code,fii, to_char(max(position_as_at)), pos
      FROM item
      WHERE fii = 2 and pos != 0
     GROUP BY id,currency_code,fii,pos
</select>

-- 
Graeme -

Mime
View raw message