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, new java.sql.Date(value.getTime()), property); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } Map<String, Object> map = new HashMap<String, Object>(); map.put("condition", condition); map.put("value", value); criteriaWithSingleValue.add(map); } This is a generated method (abator). The Date value I passed in the method, is a new java.util.Date(). And it's converted as : 1970-01-01 ... why ? I guess the value.getTime() is doing something wrong. Jeremy Jardin wrote: > > well, sure, I _always_ use java.util.Date.. > My sqlMap is an abatorGenerated one.. and it's quite big. > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" > "http://ibatis.apache.org/dtd/sql-map-2.dtd"> > <sqlMap namespace="TAB_CHIF"> > <resultMap > class="fr.gouv.finances.douane.dnsce.corinthe.metier.ibatis.bean.TabChif" > id="ibatorgenerated_BaseResultMap"> > <!-- > WARNING - This element is automatically generated by Apache iBATIS > ibator, do not modify. > This element was generated on Tue May 04 16:23:34 CEST 2010. > --> > <result column="DAT_CHIF" jdbcType="DATE" property="datChif" /> > <result column="MOIS_CHIF" jdbcType="CHAR" property="moisChif" /> > <result column="AN_CHIF" jdbcType="CHAR" property="anChif" /> > </resultMap> > <sql id="ibatorgenerated_Example_Where_Clause"> > <!-- > WARNING - This element is automatically generated by Apache iBATIS > ibator, do not modify. > This element was generated on Tue May 04 16:23:34 CEST 2010. > --> > <iterate conjunction="or" prepend="where" property="oredCriteria" > removeFirstPrepend="iterate"> > <isEqual compareValue="true" property="oredCriteria[].valid"> > ( > <iterate conjunction="and" prepend="and" > property="oredCriteria[].criteriaWithoutValue"> > $oredCriteria[].criteriaWithoutValue[]$ > </iterate> > <iterate conjunction="and" prepend="and" > property="oredCriteria[].criteriaWithSingleValue"> > $oredCriteria[].criteriaWithSingleValue[].condition$ > #oredCriteria[].criteriaWithSingleValue[].value# > </iterate> > <iterate conjunction="and" prepend="and" > property="oredCriteria[].criteriaWithListValue"> > $oredCriteria[].criteriaWithListValue[].condition$ > <iterate close=")" conjunction="," open="(" > property="oredCriteria[].criteriaWithListValue[].values"> > #oredCriteria[].criteriaWithListValue[].values[]# > </iterate> > </iterate> > <iterate conjunction="and" prepend="and" > property="oredCriteria[].criteriaWithBetweenValue"> > $oredCriteria[].criteriaWithBetweenValue[].condition$ > #oredCriteria[].criteriaWithBetweenValue[].values[0]# and > #oredCriteria[].criteriaWithBetweenValue[].values[1]# > </iterate> > ) > </isEqual> > </iterate> > </sql> > <select id="ibatorgenerated_selectByExample" > parameterClass="fr.gouv.finances.douane.dnsce.corinthe.metier.ibatis.bean.TabChifExample" > resultMap="ibatorgenerated_BaseResultMap"> > <!-- > WARNING - This element is automatically generated by Apache iBATIS > ibator, do not modify. > This element was generated on Tue May 04 16:23:34 CEST 2010. > --> > select DAT_CHIF, MOIS_CHIF, AN_CHIF > from TAB_CHIF > <isParameterPresent> > <include refid="TAB_CHIF.ibatorgenerated_Example_Where_Clause" /> > <isNotNull property="orderByClause"> > order by $orderByClause$ > </isNotNull> > </isParameterPresent> > </select> > </sqlMap> > > > nmaves wrote: >> >> 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 >>> >>> >> >> > > -- View this message in context: http://old.nabble.com/date-in-where-clause-does-not-work.-tp28447759p28458279.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