Integrity Constraints fire upon deletion.
Integrity Constraints fire upon deletion.
- Subject: Integrity Constraints fire upon deletion.
- From: Gaastra Dennis - WO Lists <email@hidden>
- Date: Wed, 25 Apr 2007 14:46:14 -0700
Dear List,
Why does WebObjects or the Frontbase Adaptor sometimes set (update)
an instance's attributes to null instead of just deleting it right
away. As such, constraints fire up. This error only happens 1 in 10
times, while deleting an instance from the database.
ec.deleteObject(trans);
session.defaultEditingContext().saveChanges();
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.FrontbasePlugIn
$FrontbaseExpression: "UPDATE "ClientTransaction" SET "branch_id" =
NULL, "office_id" = NULL, "division_id" = NULL, "client_id" = NULL
WHERE ("clientTransaction_id" = 1008834 AND "office_id" = 1000001 AND
"branch_id" = 1000003)">:
Next exception:SQL State:23 subclass = 00 -- error code:
357 -- msg: Exception condition 357. Integrity constraint violation
(CHECK, ClientTransaction._C0000000083(\"branch_id\" IS NOT NULL)).
Next exception:SQL State:23 subclass = 00 -- error code:
357 -- msg: Exception condition 357. Integrity constraint violation
(CHECK, ClientTransaction._C0000000088(\"office_id\" IS NOT NULL)).
Next exception:SQL State:40 subclass = 00 -- error code:
363 -- msg: Exception condition 363. Transaction rollback.
Thanks for any help.
With Kind Regards,
Dennis Gaastra, M.B.A.[sfu.ca], B.Sc.[ubc.ca]
Chief Technology Officer,
WEBAPPZ Systems, Inc.
HQ: (+1) 604.921.1333
Fax: (+1) 604.921.4313
Cell: (+1) 604.787.2532
Email: email@hidden
Web: www.webappz.com & www.1tracker.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden