ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Jardin <jeremy.jar...@gmail.com>
Subject Re: date in where clause does not work.
Date Wed, 05 May 2010 07:41:54 GMT

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.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
>>
>>
> 
> 

-- 
View this message in context: http://old.nabble.com/date-in-where-clause-does-not-work.-tp28447759p28457681.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