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? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Meadors Sent: 03 November 2006 13:04 To: [email protected] Subject: Re: Ibatis not returning any results What is the type of fii? It's not CHAR is it? Sometimes a CHAR will mess things up because in the db it's ' A' instead of 'A' or 'A '... Larry On 11/3/06, Rutherford, Matthew [CIB-IT] <[EMAIL PROTECTED]> wrote: > > > 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 >
