does one of the four relationships define the joins at be a composite rather 
than a single fk-pk join? it sort of looks that way, that the 
OrgRequirement.requirements relationship is defined wrong.

On Nov 16, 2010, at 12:45 PM, David Avendasora wrote:

> Just to be clear, here's the exception I get:
> 
> Caused by: java.lang.IllegalStateException: A valid global ID could not be 
> obtained for entity named OrgRequirement, relationship named requirements, 
> primary key dictionary {orgId = 1020; requirementId = 1000;}.
>       at 
> com.webobjects.eoaccess.EODatabaseContext.databaseOperationForIntermediateRowFromSourceObject(EODatabaseContext.java:4871)
>       at 
> com.webobjects.eoaccess.EODatabaseContext.recordInsertForIntermediateRowFromSourceObject(EODatabaseContext.java:4888)
>       at 
> com.webobjects.eoaccess.EODatabaseContext.relayAttributesInRelationshipSourceObjectDestinationObject(EODatabaseContext.java:4913)
>       at 
> com.webobjects.eoaccess.EODatabaseContext.relayAttributesInRelationshipSourceObjectDestinationObjects(EODatabaseContext.java:4966)
>       at 
> com.webobjects.eoaccess.EODatabaseContext.recordChangesInEditingContext(EODatabaseContext.java:6036)
>       at 
> com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:373)
>       at 
> com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
>       at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1085)
>       at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1007)
> 
> 
> On Nov 16, 2010, at 9:32 AM, David Avendasora wrote:
> 
>> Hi all,
>> 
>> I have a Many-to-Many relationship and the join table does _not_ have a 
>> compound PK. It has a normal PK with a dataType of Long. The FKs that 
>> represent the to-One relationships on the join table are simply FKs and not 
>> part of the PK.
>> 
>> I would like to flatten the toMany relationships, but when I add an object 
>> to the relationship and EOF tries to create a row in the join table it  
>> tries to create a compound PK for the join table, even though the Model is 
>> very clear as to what the PK is. 
>> 
>> Is this the normal EOF behavior to ignore the Model's PK settings for the 
>> join table and just assume that the PK is compound?
>> 
>> I've always avoided flattened relationships because every time I try to use 
>> them I run into problems and give up and go back to regular relationships 
>> because it seems the work that flattened relationships save always gets 
>> offset by the limitations they impose (either that or my limitations of 
>> ability to use them properly).
>> 
>> Dave
> 
> 
> 
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com
> 
> This email sent to msch...@pobox.com

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to