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 implicit date issue
Date Mon, 22 Jan 2007 00:20:57 GMT
The following query does not work with Oracle 9i.

<select id="queryForCaseIds" resultClass="string" parameterClass="
java.util.Date">
    select distinct case_id from (
        select case_id from case_history where last_update_date >= #value#
          union
        select case_id from task_history where last_update_date >= #value#
    )
  </select>

If I modify it to be #value:Date# as is well.  The column is a DATE in
Oracle and a java.util.Date in the parameter.  Why can ibatis not figure out
that this is a DATE?

Nathan

Mime
View raw message