Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 76018 invoked from network); 7 Aug 2006 06:34:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Aug 2006 06:34:36 -0000 Received: (qmail 91584 invoked by uid 500); 7 Aug 2006 06:34:34 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 91435 invoked by uid 500); 7 Aug 2006 06:34:34 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 91424 invoked by uid 99); 7 Aug 2006 06:34:34 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Aug 2006 23:34:34 -0700 X-ASF-Spam-Status: No, hits=2.8 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [68.142.198.105] (HELO web31310.mail.mud.yahoo.com) (68.142.198.105) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 06 Aug 2006 23:34:33 -0700 Received: (qmail 74203 invoked by uid 60001); 7 Aug 2006 06:34:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Ao/9liYJ5QCU6bp1uH8bXmD8C0FUekbE7m/VTJmSWDjrhVW+Ma4kPBz5YGsJzPK2env7ymWd8HiFS86qgFi7ksNum/kspJupenfvzJHs8iHR66rpmYbkSjdMNtuxBRaH/ikYHFY6r1GxOpolTyF/o96QaT1TW+QS0JYnDTVyWKs= ; Message-ID: <20060807063412.74201.qmail@web31310.mail.mud.yahoo.com> Received: from [202.178.112.80] by web31310.mail.mud.yahoo.com via HTTP; Sun, 06 Aug 2006 23:34:12 PDT Date: Sun, 6 Aug 2006 23:34:12 -0700 (PDT) From: Socheat KHAUV Subject: Re: SQL DELETE To: user-java@ibatis.apache.org In-Reply-To: <1154931896.16554.267777890@webmail.messagingengine.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-920334924-1154932452=:73949" Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --0-920334924-1154932452=:73949 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Do we have another way beside using trigger and ON DELETE CASCADE? this is DBMS functions, beside using DBMS Does iBatis can delete the child record auto when we delete the master record ? Nils Winkler wrote: In Oracle I define this at the table level using "ON DELETE CASCADE" on the foreign key relationship. On Sun, 6 Aug 2006 23:13:31 -0700 (PDT), "Socheat KHAUV" said: > Dear iBatis user, > > Does iBatis support auto delete data dependency when we delete master > record ? > if it is support could tell me way to do ? > > thank in advance, > PkayJava > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs.Try it free. -- ================================== nils@nilswinkler.com --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs.Try it free. --0-920334924-1154932452=:73949 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Do we have another way beside using trigger and  ON DELETE CASCADE?
this is DBMS functions,

beside using DBMS

Does iBatis can delete the child record auto when we delete the master record ?


Nils Winkler <nils@nilswinkler.com> wrote:
In Oracle I define this at the table level using "ON DELETE CASCADE" on
the foreign key relationship.

On Sun, 6 Aug 2006 23:13:31 -0700 (PDT), "Socheat KHAUV"
said:
> Dear iBatis user,
>
> Does iBatis support auto delete data dependency when we delete master
> record ?
> if it is support could tell me way to do ?
>
> thank in advance,
> PkayJava
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs.Try it free.
--
==================================
nils@nilswinkler.com


Yahoo! Music Unlimited - Access over 1 million songs. Try it free. --0-920334924-1154932452=:73949--