just thought, but
did you check your model?
I once had keys confused somehow in the model itself and it took a little while
to notice because the new database had mostly similar key values....
On Dec 29, 2010, at 1:21 PM, Jeff Schmitz wrote:
> Hello,
> I'm not sure how the following can happen, but I seem to have figured out
> a way to make it so. My code creates a new EO (user) and then adds an
> existing EO (this) to a "many to many" relationship of the new EO as shown
> with added logged messages:
>
> User user = User.createUser(this.editingContext(), password,
> eMail, first, forumName, last, lastYearUser, userName, real, thisYear,
> useFBAccount, useFBLogin);
> this.editingContext().saveChanges();
> EOGlobalID poolID =
> this.editingContext().globalIDForObject(this);
> EOGlobalID userID =
> this.editingContext().globalIDForObject(user);
> System.out.println("Adding user " + user.name() + " with ID " +
> userID + " to Pool " + this.name() + " with id " + poolID);
> user.addToPoolsRelationship(this);
> this.editingContext().saveChanges();
>
> Note that the first saveChanges after creation of the new EO works fine. But
> after the second saveChanges I get the below constraint error. The strange
> part is that when printing out the ID's of the EO's, it looks like it should
> be using a User EO with an ID of 1000009. However, the integrity error makes
> it look like it tried to add "this" to a user with ID 1000007.
>
>
> Dec 29 11:53:24 netBrackets[9999] (Pool.java:407) INFO
> com.netbracketsfw.model.Pool - Adding user Wilma with ID
> _EOIntegralKeyGlobalID[User (java.lang.Integer)1000009] to Pool VVV0 with id
> _EOIntegralKeyGlobalID[Pool (java.lang.Integer)1000005]
>
> Dec 29 11:53:24 netBrackets[9999] (ERXDatabaseContextDelegate.java:175) INFO
> er.transaction.adaptor.Exceptions - Database Exception occured:
> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed:
> <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "INSERT
> INTO "PoolUser"("userId", "poolId") VALUES (1000007, 1000005)" withBindings:
> >:
> Next exception:SQL State:23 subclass = 00 -- error code: 358 --
> msg: Exception condition 358. Integrity constraint violation (PRIMARY KEY,
> PoolUser.PRIMARY_KEY_PoolUser_userId_poolId(userId=1000007,poolId=1000005)).
> Next exception:SQL State:40 subclass = 00 -- error code: 363 --
> msg: Exception condition 363. Transaction rollback.
>
> Finally, I'm using Wonder, with the InverseRelationshipUpdater turned on,
> i.e. addToPools gets called.
>
> public void addToPoolsRelationship(com.netbracketsfw.model.Pool object) {
> if (_User.LOG.isDebugEnabled()) {
> _User.LOG.debug("adding " + object + " to pools relationship");
> }
> if
> (er.extensions.eof.ERXGenericRecord.InverseRelationshipUpdater.updateInverseRelationships())
> {
> addToPools(object);
> }
> else {
> addObjectToBothSidesOfRelationshipWithKey(object, "pools");
> }
> }
>
> any ideas what's going on?
>
> Thanks!
> Jeff
>
> _______________________________________________
> 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/jtayler%40oeinc.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]
