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

Reply via email to