Return-Path: 
 <user-java-return-8321-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 57521 invoked from network); 7 Aug 2006 15:38:58 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 7 Aug 2006 15:38:58 -0000
Received: (qmail 41490 invoked by uid 500); 7 Aug 2006 15:38:56 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 41314 invoked by uid 500); 7 Aug 2006 15:38:56 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 41297 invoked by uid 99); 7 Aug 2006 15:38:56 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Aug 2006 08:38:55 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com
 designates 64.233.182.190 as permitted sender)
Received: from [64.233.182.190] (HELO nf-out-0910.google.com) (64.233.182.190)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Aug 2006 08:38:55 -0700
Received: by nf-out-0910.google.com with SMTP id x37so1953639nfc
        for <user-java@ibatis.apache.org>;
 Mon, 07 Aug 2006 08:38:33 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=WFsN6qdaVUOTFE6ZD6YRpDRugOR31idQOv2Y32UK5kqH/Rr5xfJlqz1Z/SDm6/t/wrOah9lX5g3QZ3NhHOSXYTGk4EqMpLeCr14ZpsVbLf03AFnzv7YlD56yxlHZlqkpHRUyFUlu8pJLesZB7tPtHBlAVpKy7X2vioXAs9A/ZeM=
Received: by 10.78.133.10 with SMTP id g10mr2432237hud;
        Mon, 07 Aug 2006 08:38:33 -0700 (PDT)
Received: by 10.78.138.1 with HTTP; Mon, 7 Aug 2006 08:38:33 -0700 (PDT)
Message-ID: <16178eb10608070838i5c2d5812l616478bdcb14f1ff@mail.gmail.com>
Date: Mon, 7 Aug 2006 09:38:33 -0600
From: "Clinton Begin" <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org, lmeadors@apache.org
Subject: Re: SQL DELETE
In-Reply-To: <a10a823c0608070425s5aece4cfgfcfe604fcaae74a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_88943_3184797.1154965113387"
References: <16178eb10608062345lb7ad420mae12e9e49fc7c2b6@mail.gmail.com>
	 <20060807073706.62877.qmail@web34703.mail.mud.yahoo.com>
	 <a10a823c0608070425s5aece4cfgfcfe604fcaae74a@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_88943_3184797.1154965113387
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Of course for relational integrity, it would have to be:

<update id="saveSearchControls" parameterClass="map">
      begin
              delete from Child where parentId = #value# ;
              delete from Parent where parentId = #value# ;
      end;
</update>

;-)

Clinton

On 8/7/06, Larry Meadors <lmeadors@apache.org> wrote:
>
> Not like <select> can, no.
>
> I am hoping this will not turn into another "we can't use any
> database-specific features" thread, but several databases (like
> Oracle) will let you do things like this:
>
> <update id="saveSearchControls" parameterClass="map">
>        begin
>                delete from Parent where parentId = #value# ;
>                delete from Child where parentId = #value# ;
>        end;
> </update>
>
> That is a nice workaround for environments where you are not allowed
> to create stored procedures. ;-)
>
> Larry
>
>
> On 8/7/06, Fred Janon <fjanon@yahoo.com> wrote:
> > That said, is there a way in iBatis to mimic a CASCADE DELETE by
> > executing several SQL statements in an iBatis SQL Map? Like selected
> > the elements in the child table with the FK of the master table and
> > deleting the selected child rows?
> >
> > The documentation says that we can even put several SQL statements in
> > the SQL map if the JDBC driver supports it... Would it be the way to do
> > it?
> >
> > --- Clinton Begin <clinton.begin@gmail.com> wrote:
> >
> > > No.  iBATIS is not an Object Relational Mapper.  It is not aware of
> > > relationships and therefore does not automatically delete related
> > > records.
> > >
> > > Clinton
> > >
> > > On 8/7/06, Socheat KHAUV <khauv_socheat@yahoo.com> wrote:
> > > >
> > > > 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.<
> http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/+%0A
> >
> > > >
> > > >
> > >
> >
> >
>

------=_Part_88943_3184797.1154965113387
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Of course for relational integrity, it would have to be:<br><br>&lt;update id=&quot;saveSearchControls&quot; parameterClass=&quot;map&quot;&gt;<br> &nbsp; &nbsp; &nbsp; begin<br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; delete from Child where parentId = #value# ;
<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; delete from Parent where parentId = #value# ;<br>&nbsp; &nbsp; &nbsp; end;<br>&lt;/update&gt;<br><br>;-)<br><br>Clinton<br><br><div><span class="gmail_quote">On 8/7/06, <b class="gmail_sendername">Larry Meadors</b> &lt;<a href="mailto:lmeadors@apache.org">
lmeadors@apache.org</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Not like &lt;select&gt; can, no.<br><br>I am hoping this will not turn into another &quot;we can't use any
<br>database-specific features&quot; thread, but several databases (like<br>Oracle) will let you do things like this:<br><br>&lt;update id=&quot;saveSearchControls&quot; parameterClass=&quot;map&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; begin<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; delete from Parent where parentId = #value# ;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; delete from Child where parentId = #value# ;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end;<br>&lt;/update&gt;<br><br>That is a nice workaround for environments where you are not allowed
<br>to create stored procedures. ;-)<br><br>Larry<br><br><br>On 8/7/06, Fred Janon &lt;<a href="mailto:fjanon@yahoo.com">fjanon@yahoo.com</a>&gt; wrote:<br>&gt; That said, is there a way in iBatis to mimic a CASCADE DELETE by
<br>&gt; executing several SQL statements in an iBatis SQL Map? Like selected<br>&gt; the elements in the child table with the FK of the master table and<br>&gt; deleting the selected child rows?<br>&gt;<br>&gt; The documentation says that we can even put several SQL statements in
<br>&gt; the SQL map if the JDBC driver supports it... Would it be the way to do<br>&gt; it?<br>&gt;<br>&gt; --- Clinton Begin &lt;<a href="mailto:clinton.begin@gmail.com">clinton.begin@gmail.com</a>&gt; wrote:<br>&gt;<br>
&gt; &gt; No.&nbsp;&nbsp;iBATIS is not an Object Relational Mapper.&nbsp;&nbsp;It is not aware of<br>&gt; &gt; relationships and therefore does not automatically delete related<br>&gt; &gt; records.<br>&gt; &gt;<br>&gt; &gt; Clinton<br>&gt; &gt;
<br>&gt; &gt; On 8/7/06, Socheat KHAUV &lt;<a href="mailto:khauv_socheat@yahoo.com">khauv_socheat@yahoo.com</a>&gt; wrote:<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; Do we have another way beside using trigger and&nbsp;&nbsp;ON DELETE CASCADE?
<br>&gt; &gt; &gt; this is DBMS functions,<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; beside using DBMS<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; Does iBatis can delete the child record auto when we delete the<br>&gt; &gt; master<br>&gt; &gt; &gt; record ?
<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; *Nils Winkler &lt;<a href="mailto:nils@nilswinkler.com">nils@nilswinkler.com</a>&gt;* wrote:<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; In Oracle I define this at the table level using &quot;ON DELETE
<br>&gt; &gt; CASCADE&quot; on<br>&gt; &gt; &gt; the foreign key relationship.<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; On Sun, 6 Aug 2006 23:13:31 -0700 (PDT), &quot;Socheat KHAUV&quot;<br>&gt; &gt; &gt; said:<br>&gt; &gt; &gt; &gt; Dear iBatis user,
<br>&gt; &gt; &gt; &gt;<br>&gt; &gt; &gt; &gt; Does iBatis support auto delete data dependency when we delete<br>&gt; &gt; master<br>&gt; &gt; &gt; &gt; record ?<br>&gt; &gt; &gt; &gt; if it is support could tell me way to do ?
<br>&gt; &gt; &gt; &gt;<br>&gt; &gt; &gt; &gt; thank in advance,<br>&gt; &gt; &gt; &gt; PkayJava<br>&gt; &gt; &gt; &gt;<br>&gt; &gt; &gt; &gt;<br>&gt; &gt; &gt; &gt; ---------------------------------<br>&gt; &gt; &gt; &gt; Yahoo! Music Unlimited - Access over 1 million 
songs.Try it free.<br>&gt; &gt; &gt; --<br>&gt; &gt; &gt; ==================================<br>&gt; &gt; &gt; <a href="mailto:nils@nilswinkler.com">nils@nilswinkler.com</a><br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt; ------------------------------
<br>&gt; &gt; &gt; Yahoo! Music Unlimited - Access over 1 million songs. Try it<br>&gt; &gt;<br>&gt; free.&lt;<a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/+%0A">http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/+%0A
</a>&gt;<br>&gt; &gt; &gt;<br>&gt; &gt; &gt;<br>&gt; &gt;<br>&gt;<br>&gt;<br></blockquote></div><br>

------=_Part_88943_3184797.1154965113387--