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
