Re: SQL DELETE

Regardless of how huge your processes are and how complex your tables areyou will need to execute delete commands against them, in order, so as not to break relational integrity constraints.  The nice thing about iBATIS is that you can do batch deletes easily and as much as you want.  I'm not

Re: SQL DELETE

OK, let's go over this again: iBATIS is not an Object / Relational Mapper. It is not intended to track these relationships for you. RDBMS = Relational DataBase Management System. An RDBMS is intended to track these relationships for you. If your particular RDBMS is incapable of doing that, or

Re: SQL DELETE

Yesh of coz your sql is right for two table,how about three table or more and more tables that have relationship together,       begin   delete ... and more   delete ...               delete from Child2 where parentId in select childId from Child1 where parentId = #value#

Re: SQL DELETE

Of course for relational integrity, it would have to be:       begin               delete from Child where parentId = #value# ;               delete from Parent where parentId = #value# ;      end;;-)ClintonOn 8/7/06, Larry Meadors < [EMAIL PROTECTED]> wrote:Not like can, no.I am hoping this wil

Re: SQL DELETE

Not like 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: begin delete from Parent where parentId = #value# ; delete from Child wher

Re: SQL DELETE

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 statem

RE: SQL DELETE

    CREATE TABLE CHILD (F1 from ROOT_TABLE VARCHAR (80), FOREIGN KEY (F1) REFERENCES ROOT_TABLE (USR_ID) ON DELETE CASCADE);   THis will work.     Thanks n Regards, = Rambabu Piridi. Software Engineer, Wipro Technologies, Madhapur, Hyderabad.   e-Mail : [EMAIL

Re: SQL DELETE

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

Re: SQL DELETE

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" ont

Re: SQL DELETE

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" <[EMAIL PROTECTED]> said: > Dear iBatis user, > > Does iBatis support auto delete data dependency when we delete master > record ? > if it

SQL DELETE

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.