Re: date in where clause does not work.

2010-05-05 Thread Jeff Butler
(a)ibator converts these to java.sql.Date to force iBATIS to use the DateOnlyTypeHandler for database fields that are truly just dates - not date/time or timestamp. This is working in lots of tests. What is the type of the database field? Is it truly just a date, or is it a timestamp? Also, in

Re: date in where clause does not work.

2010-05-05 Thread Jeremy Jardin
Today, I'm having other kind of pb... My select request return too much rows.. I'm still lauching the same test.. and, in debug mode, i've seen something wrong here : protected void addCriterionForJDBCDate(String condition, Date value, String property) { addCriterion(condition

Re: date in where clause does not work.

2010-05-05 Thread Jeremy Jardin
well, sure, I _always_ use java.util.Date.. My sqlMap is an abatorGenerated one.. and it's quite big. http://ibatis.apache.org/dtd/sql-map-2.dtd";> ( $oredCriteria[].criteriaWithoutValue[]$ $ore

Re: date in where clause does not work.

2010-05-04 Thread Nathan Maves
Wel ALWAYS use java.util.Date send us your sqlmap On Tue, May 4, 2010 at 10:03 AM, Jeremy Jardin wrote: > > Ok, I'm doing something like that. > > TabChifExample criteria = new TabChifExample(); > criteria.createCriteria().andDatChifGreaterThan (new java.util.Date() ); > .. etc... > > I've seen

Re: date in where clause does not work.

2010-05-04 Thread Jeremy Jardin
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 do

Re: date in where clause does not work.

2010-05-04 Thread Larry Meadors
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 wrote: > > Hi, > > I'm simply trying to build a request with Date comparaisons.. and ibatis > still reply me empty list.. > > My gene