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 15:11:46 GMT
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: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com]On Behalf
Of Larry Meadors
Sent: 03 November 2006 14:53
To: user-java@ibatis.apache.org; 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 <ibatis.user@gjsweeney.com> 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 -
>

Mime
View raw message