I think you've hit the nail on the head Larry, it's not being parsed into java.sql.Date correctly as a result of the to_char.
thanks Matt -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Meadors Sent: 03 November 2006 14:53 To: [email protected]; Graeme J Sweeney Subject: Re: Ibatis not returning any results What is returned by to_char(max(position_as_at))? Larry On 11/3/06, Graeme J Sweeney <[EMAIL PROTECTED]> wrote: > 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 - >
