Ya, you know, does an ec, I'm sure you know... lol sorry, it does an insert :)
yes, it locks the EC. There's no other other validation errors.In fact the exception handling is set up to do the resave, and in most circumstances this resave works correctly, however sometimes it doesn't. Personally I'm purely convinced it's related to the load, since if I don't try a resave I'm getting a lot more of these errors. And again, on the instance with low traffic, I never get this exception.
Alan On 6-Dec-08, at 2:12 AM, Chuck Hill wrote:
On Dec 5, 2008, at 3:09 PM, Alan Zebchuk wrote:In my case, I'm running on 5.4.3 and it is a direct action that creates an EC, does an EC, and that's all.Alan"does an EC"?Sounds kinky! Does it tie up, er lock, the EC before it does this? Are there any validation (or other exceptions) and a resave?ChuckOn 5-Dec-08, at 7:04 PM, Ken Anderson wrote:What release of webobjects are you both running? On Dec 5, 2008, at 10:59 AM, Simon McLean wrote:Hi -We've seen this too, but running on MySQL. It's really bizarre. The EO's are built, the relationship set but then sometime between saveChanges() and the raw SQL being sent to the DB it seems to forget the foreign key in the relationship.I've asked myself the same question too: how the hell did it get passed model validation ?!!Unfortunately we've never got to the bottom of it either... Simon On 5 Dec 2008, at 15:22, Alan Zebchuk wrote:I seem to get the following exception in one of my applications lately:com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor.PostgresqlExpression: "INSERT INTO "......Next exception:SQL State:23502 -- error code: 0 -- msg: ERROR: null value in column "oid_person_type" violates not-null constraintAny ideas how this could happen? The relationship and attribute are marked as mandatory in the EO Model, so I'm not sure how this would even pass through the validation?It might be possible that this is related to load on the application. I have 2 instance of this application, one which has a much heavier load. This error is only occurring on this instance.Any help is greatly appreciated, Thanks, Alan _______________________________________________ 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/simon_mclean%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/kenlists%40anderhome.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/chill%40global-village.net This email sent to [EMAIL PROTECTED]-- Chuck Hill Senior Consultant / VP DevelopmentPractical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.http://www.global-village.net/products/practical_webobjects _______________________________________________ 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/alan.zebchuk%40fuegodigitalmedia.com This email sent to [EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
