Return-Path: <vincent.siveton@staff.mcgill.ca>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 74558 invoked by uid 99); 14 Jan 2005 11:52:48 -0000
X-ASF-Spam-Status: No, hits=0.2 required=10.0
	tests=NO_REAL_NAME
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from deluge.CC.McGill.CA (HELO deluge.cc.mcgill.ca) (132.206.27.50)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 14 Jan 2005 03:52:46 -0800
Received: from mailscan2.cc.mcgill.ca (mailscan2.CC.McGill.CA
 [132.216.77.249])
	by deluge.cc.mcgill.ca (8.12.11/8.12.3) with ESMTP id j0EBqhhb010507;
	Fri, 14 Jan 2005 06:52:43 -0500 (EST)
Received: from wgrappe3.CC.McGill.CA (wgrappe3.CC.McGill.CA [132.216.47.126])
	by mailscan2.cc.mcgill.ca (8.13.0/8.13.0) with ESMTP id j0EBqS7x004120;
	Fri, 14 Jan 2005 06:52:29 -0500 (EST)
Received: from wgrappe3.CC.McGill.CA (localhost.localdomain [127.0.0.1])
	by wgrappe3.CC.McGill.CA (8.12.11/8.12.11) with ESMTP id j0EBqRV1007934;
	Fri, 14 Jan 2005 06:52:27 -0500
Received: (from apache@localhost)
	by wgrappe3.CC.McGill.CA (8.12.11/8.12.11/Submit) id j0EBqR9Q007931;
	Fri, 14 Jan 2005 06:52:27 -0500
Received: from ip216-239-81-159.vif.net (ip216-239-81-159.vif.net
 [216.239.81.159])
	by webmail.mcgill.ca (IMP) with HTTP
	for <vincent.siveton@staff.mcgill.ca>; Fri, 14 Jan 2005 06:52:27 -0500
Message-ID: <1105703547.41e7b27b140d9@webmail.mcgill.ca>
Date: Fri, 14 Jan 2005 06:52:27 -0500
From: vincent.siveton@staff.mcgill.ca
To: ibatis-user-java@incubator.apache.org,
        Philip Chan <pchan@locussystems.com>
Cc: ibatis-user-java@incubator.apache.org
Subject: Re: why delete by date not working?
References: <93B63CD749AF42408983965270CA41B2249775@ls2.lsi.locussystems.com>
In-Reply-To: <93B63CD749AF42408983965270CA41B2249775@ls2.lsi.locussystems.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.2.6
X-Originating-IP: 216.239.81.159
X-Virus-Checked: Checked

Hi Philip,

An other error is that you dont define correctly your parameterClass. It should
be parameterClass="java.util.Date"

V.

Selon Philip Chan <pchan@locussystems.com>:

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