• 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: MySql plugin / driver bug
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: MySql plugin / driver bug


  • Subject: Re: MySql plugin / driver bug
  • From: Chuck Hill <email@hidden>
  • Date: Wed, 6 Jan 2010 16:06:39 -0800

Why does it need an ID field? Do the relationship keys not make it unique? Can you make it an EOGenericRecord?


On Jan 6, 2010, at 2:07 PM, Mark Woollard wrote:

If you have an entity with no exposed properties incorrect SQL gets generated (mysql + plugin). I have an entity who's sole purpose is to map between two other entities, it contains no data itself, just two one:many relationships, and an id field, so three fields in all (id, and two for the relationships). This causes SQL to be generated 'select t0.relationship1Id, t0., t0.relationship2 FROM ...'. If I add a dummy data property to the entity you get 'select t0.relationship1Id, t0.dummy, t0.relationship2 FROM ...' generated. Seems that an assumption is being made that at least one exposed property will exist for the EO. Is this likely to be the plugin or the driver or WO itself?

Thanks
Mark


--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








_______________________________________________
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: MySql plugin / driver bug
      • From: Mark Woollard <email@hidden>
References: 
 >MySql plugin / driver bug (From: Mark Woollard <email@hidden>)

  • Prev by Date: Re: LEWOStuff (the stuff with JSON-RPC!)
  • Next by Date: Re: MySql plugin / driver bug
  • Previous by thread: MySql plugin / driver bug
  • Next by thread: Re: MySql plugin / driver bug
  • Index(es):
    • Date
    • Thread