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.

Reply via email to