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 -
