I have seen this about 3 or 4 times long time ago - IIRC, the problem was 
something to do with either EC or OSC locking.

In any case, I use MySQL - even the majority of WO users, except Chuck Hill, 
use MySQL - and it works.

-Kieran

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/kieran_lists%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