ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <nathan.ma...@gmail.com>
Subject Re: date in where clause does not work.
Date Tue, 04 May 2010 16:14:55 GMT
Wel ALWAYS use java.util.Date

send us your sqlmap


On Tue, May 4, 2010 at 10:03 AM, Jeremy Jardin <jeremy.jardin@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.jardin@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-unsubscribe@ibatis.apache.org
> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> > For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message