Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of
 matthew.rutherford@citigroup.com designates 199.67.203.180 as permitted
 sender)
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Ibatis not returning any results
Date: Fri, 3 Nov 2006 15:33:11 -0000
Message-ID: <3FA2DA52ED20E140A13FD937E0BC011303D8119B@Exukmb29.eur.nsroot.net>
Thread-Topic: Ibatis not returning any results
Thread-Index: Acb/WvoagGnYZpn8TaukwP0euG2DSQAAhPYw
From: "Rutherford, Matthew [CIB-IT]" <matthew.rutherford@citigroup.com>
To: <user-java@ibatis.apache.org>

Unfortunately, I tried this but no luck.  Also set =
jdbcType=3D"TIMESTAMP" on the positionAsAt result tag too but nothing =
gained.  Again, a dumb select all items query works fine for me, just =
not the slightly more complex query below...

-----Original Message-----
From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com]On Behalf
Of Larry Meadors
Sent: 03 November 2006 15:14
To: user-java@ibatis.apache.org
Subject: Re: Ibatis not returning any results


Oh, position_as_at is a date? If so, then yeah: Removing the to_char
should fix it up.

Larry


On 11/3/06, Rutherford, Matthew [CIB-IT]
<matthew.rutherford@citigroup.com> wrote:
> 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=3D"getLatestPositionByFii" resultMap=3D"result">
> >      SELECT id,currency_code,fii, to_char(max(position_as_at)), pos
> >       FROM item
> >       WHERE fii =3D 2 and pos !=3D 0
> >      GROUP BY id,currency_code,fii,pos
> > </select>
> >
> > --
> > Graeme -
> >
>