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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>* 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.
> > --
> > ==================================
> > [EMAIL PROTECTED]
> >
> >
> > ------------------------------
> > 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>
> >
> >
>
