• 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: Database and EO Modeller
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database and EO Modeller


  • Subject: Re: Database and EO Modeller
  • From: Zak Burke <email@hidden>
  • Date: Tue, 04 Apr 2006 15:16:30 -0400

Jeffrey Pearson wrote on 4/4/06 1:58 PM:
After viewing the video, it looks like I am going to be much happier if I copy off the tables, use EOModeler to actually create the tables in the db and then import the data. It looks like some invisible plumbing is set up by using EOModeler to generate the database tables.

As David and Paul have pointed out, you probably don't need to use EOModeler to recreate your database tables. One hiccup they didn't mention is that EOF is unaware of DB constraints. This can be a major issue when dealing with legacy DBs and it will cause major headaches when you are persisting complex EOs that have a bunch of relations.


For example, say you have the relationship File -->> Attribute and you create a new File with a bunch of Attribute relations. EOF tends to process things in order alphabetically, meaning it first runs statements to insert the Attributes, and then to insert the File. If you have a foreign key constraint on Attribute that references the File PK, your DB will throw an error at this point.

Some DBs will let you temporarily disable constraints, thus avoiding this error. This has not worked for me with MySQL 4.1.x. (It solved one problem but introduced others, and that's a topic for another thread.)

Many WO folks will tell you that you don't need DB constraints as long as your EOModel is correctly constrained. This is true, but it doesn't address the situation of dealing with a legacy DB which you don't control the constraints on. At this point, the conversation usually descends into a flamewar, so I'll leave it there.

Good luck,

zak.
_______________________________________________
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: Database and EO Modeller
      • From: Ken Anderson <email@hidden>
References: 
 >Database and EO Modeller (From: Jeffrey Pearson <email@hidden>)

  • Prev by Date: Re: Database and EO Modeller
  • Next by Date: Re: Problem of Building project converted from Objective C
  • Previous by thread: Re: Database and EO Modeller
  • Next by thread: Re: Database and EO Modeller
  • Index(es):
    • Date
    • Thread