You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Nathan Maves <na...@gmail.com> on 2007/01/22 01:20:57 UTC

implicit date issue

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