Hi Kieran, Yeah, I haven't changed anything except to add an attribute to the intermediary table and I also exposed the two to-one relationships in the intermediary table as class properties.
I just deleted everything and recreated it again and I'm still getting the same error. I don't see any SQL getting logged that indicates it's trying to insert a row. It seems to be erring out before it tries to write to the database. Thanks for helping, Johnny On Feb 23, 2010, at 5:05 PM, Kieran Kelleher wrote: > > On Feb 23, 2010, at 3:55 PM, Johnny Miller wrote: > >> Actually, there is no "primary" key. There are just the two >> "multi-occurence" keys for the two foreign keys that are propagated by the >> relationships. > > Is the join table setup **exactly** the same as if you let Entity Modeler > create it automatically for you via the relationship wizard? If it was, the > join would be created automatically. > > >> >> I thought that was OK because that's the default when you create a >> multi-to-multi join. And I do the exact same thing in another model, which >> is the really perplexing part. >> >> Do you think just creating a primary key in the database that is auto >> incremented by MySQL would solve it? > > IMHO, Bad idea ..... probably will not work ....... one reason is EOF has no > clue what PK was assigned by MySQL automatically in an autoincrement > field...... probably more reasons too. If that worked, then why would we even > need EO PK TABLE. EOF assigned PKs _before_ inserting a record in the > database. MYSQL autoincrement assignment happens _after_ the query is > received to insert a record in a table. > > >> >> Thanks Don. >> >> >> >> >> On Feb 23, 2010, at 10:49 AM, Don Lindsay wrote: >> >>> This sounds like you have a compound primary key? A primary key with more >>> than one field or that your primary key is not something that WebObjects >>> can generate (string, etc). >>> >>> The easiest way to use web objects is to create a primary key that is a >>> number and use it. Not use other fields in the table, just create a number >>> field that is the primary key this will save you lots of hair pulling. >>> >>> Don >>> On Feb 23, 2010, at 3:00 PM, Johnny Miller wrote: >>> >>>> Hi, >>>> >>>> I have a many to many join with flattened relationships that I created >>>> using the new relationship wizard in Entity Modeler. >>>> >>>> I then added a class property to the intermediary table and changed the >>>> class name from EOGeneric record to an appropriate one for the entity and >>>> package. Basically I need to know the "order" of the objects in the table >>>> so I ascribed a position value. >>>> >>>> After I create the object and attempt to save it I'm getting the error >>>> "failed to provide new primary keys for entity". I've checked the >>>> database and the table exists, the foreign keys are created and I've >>>> actually compared it to another table/model where I've done exactly the >>>> same thing without an issue. >>>> >>>> >>>> I'm using ... >>>> WO 5.4.3 >>>> Recent version of Wonder >>>> MySQL 5.1.37, using the MySQL plugin supplied by someone on the list . >>>> OS X 10.6 >>>> >>>> stack trace: >>>> >>>> IllegalStateException: Adaptor >>>> com.webobjects.jdbcadaptor.jdbcadap...@779a639b failed to provide new >>>> primary keys for entity 'MAP_Gallery_Image' >>>> at >>>> com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordinator(EODatabaseContext.java:5713) >>>> at >>>> com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:370) >>>> at >>>> com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) >>>> at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:981) >>>> at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:903) >>>> at >>>> com.kahalawai.components.pages.media.SetGalleryImagesPage.saveChanges(SetGalleryImagesPage.java:63) >>>> ... skipped 68 stack elements >>>> >>>> I don't see an insert SQL command in the SQL log. >>>> >>>> >>>> Johnny Miller >>>> Kahalawai Media Corp >>>> http://www.kahalawai.com >>>> >>>> >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/pccdonl%40mac.com >>>> >>>> This email sent to [email protected] >>> >> >> Johnny Miller >> Kahalawai Media Corp >> http://www.kahalawai.com >> >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com >> >> This email sent to [email protected] > Johnny Miller Kahalawai Media Corp http://www.kahalawai.com
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
