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 Fri, 14 Jan 2005 13:55:25 GMT
Hi Philip,

The best way to fix this problem is to see what the actual SQL is.  
I suggest you try to setup P6Spy.  I feel that P6Spy should be the defacto SQL snooper for
project.  The best part is it tells you the dynamic sql and also the sql after the substitution.

It can get any better than that.  There are also other sub project that have spawned using
It has saved me a lot of time.

It is also very easy to setup.  Take a look at it.  http://www.p6spy.com/

- 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 

View raw message