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