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]

 _______________________________________________
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]

Reply via email to