ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prashanth Sukumaran <prashanthsukuma...@yahoo.com>
Subject Re: why delete by date not working?
Date Thu, 13 Jan 2005 22:33:34 GMT
Hi Philip,

I think you are supposed to have #value# instead of #exectime#.  You can use a paramname other
than "value" if it is passed in a hashmap were the key is "paramname" or a bean where the
"paramname" is the field defined there.

Thanks
Prashanth.

--- Philip Chan <pchan@locussystems.com> wrote:

> 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.
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Mime
View raw message