Hi Philip,
An other error is that you dont define correctly your parameterClass. It should
be parameterClass="java.util.Date"
V.
Selon Philip Chan <[EMAIL PROTECTED]>:
> Hi
>
> I have this delete statement
>
> java.util.Date now = new Date();
> SqlMapClient client = null;
> Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
> client = SqlMapClientBuilder.buildSqlMapClient(reader);
>
> client.delete("ActivityLog.PurgeDate", now);
>
> Inside sqlmap.xml
> <delete id="ActivityLog.PurgeDate" parameterClass="date">
> <![CDATA[
> delete from activitylog al where where al.exectime <= #exectime#
> ]]>
> </delete>
>
> The record never got deleted.
>
> I am using ibatis 2.0.x and oracle 9.
>
