• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Cascading Deletes in WO and DB
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Cascading Deletes in WO and DB


  • Subject: Re: Cascading Deletes in WO and DB
  • From: Ken Anderson <email@hidden>
  • Date: Fri, 8 Jun 2007 12:28:52 -0400

David,

Is there a reason you have them in your DB? It's far safer to implement the cascade deletes in WO so you don't have to worry about your object graph and the database getting out of sync.

To answer your question, the DB or WO will win at different times because of the order of operations generated from WO. I don't think it will be a problem though, since I don't believe WO cares if the number of deleted rows fails to match the number of deleted objects.

Ken

On Jun 8, 2007, at 11:57 AM, David Avendasora wrote:

Hi all,

I have a question regarding the best place to handle cascading deletions. Right now both my database (MS SQLServer) and my EOModel have cascading deletes defined on several relationships. The EOModel and database mirror each other's cascade settings.

Is this going to confuse WO if it goes to delete a related object only to find that the DB has already deleted it (I'm assuming that the database will have deleted the related record before WO gets around to it)?

Thanks,

Dave
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anderhome.com


This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Cascading Deletes in WO and DB
      • From: David Avendasora <email@hidden>
References: 
 >Cascading Deletes in WO and DB (From: David Avendasora <email@hidden>)

  • Prev by Date: Re: validationFailedWithException not being called
  • Next by Date: Re: Cascading Deletes in WO and DB
  • Previous by thread: Cascading Deletes in WO and DB
  • Next by thread: Re: Cascading Deletes in WO and DB
  • Index(es):
    • Date
    • Thread