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.
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? 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/archive%40mail-archive.com This email sent to [email protected]
