Wel ALWAYS use java.util.Date
send us your sqlmap
On Tue, May 4, 2010 at 10:03 AM, Jeremy Jardin <jeremy.jar...@gmail.com>wrote:
>
> Ok, I'm doing something like that.
>
> TabChifExample criteria = new TabChifExample();
> criteria.createCriteria().andDatChifGreaterThan (new java.util.Date() );
> .. etc...
>
> I've seen in the example class that the java.util.Date is casted in
> java.sql.Date..
>
>
>
> Larry Meadors wrote:
> >
> > Hm, odd - I've done this hundreds of times with oracle - just passing
> > a Date object.
> >
> > Send the relevant code.
> >
> > Larry
> >
> >
> > On Tue, May 4, 2010 at 9:11 AM, Jeremy Jardin <jeremy.jar...@gmail.com>
> > wrote:
> >>
> >> Hi,
> >>
> >> I'm simply trying to build a request with Date comparaisons.. and ibatis
> >> still reply me empty list..
> >>
> >> My generated request in logs :
> >> DEBUG - [] - [main] (JakartaCommonsLoggingImpl.java:27) - {conn-100000}
> >> Connection
> >> DEBUG - [] - [main] (JakartaCommonsLoggingImpl.java:27) - {conn-100000}
> >> Preparing Statement: select * from TAB_CHIF where (DAT_CHIF
> >>>?)order by DAT_CHIF
> >> DEBUG - [] - [main] (JakartaCommonsLoggingImpl.java:27) - {pstm-100001}
> >> Executing Statement: select * from TAB_CHIF where (DAT_CHIF
> >>>?)order by DAT_CHIF
> >> DEBUG - [] - [main] (JakartaCommonsLoggingImpl.java:27) - {pstm-100001}
> >> Parameters: [2010-05-04]
> >> DEBUG - [] - [main] (JakartaCommonsLoggingImpl.java:27) - {pstm-100001}
> >> Types: [java.sql.Date]
> >>
> >> If I launch handly the same request (with a date parsing) in my oracle
> >> client, there's one row.
> >> select * from TAB_CHIF where(DAT_CHIF > to_date('2010-05-04',
> >> 'yyyy-MM-dd'));
> >>
> >>
> >> I guess I've got a dateFormat matter.. but what's the workaround ?
> >>
> >> Thanks.
> >> Jeremy
> >> --
> >> View this message in context:
> >>
> http://old.nabble.com/date-in-where-clause-does-not-work.-tp28447759p28447759.html
> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> >> For additional commands, e-mail: user-java-h...@ibatis.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> > For additional commands, e-mail: user-java-h...@ibatis.apache.org
> >
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/date-in-where-clause-does-not-work.-tp28447759p28449474.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
