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
