Re: EO error on saveChanges for deleted object
Re: EO error on saveChanges for deleted object
- Subject: Re: EO error on saveChanges for deleted object
- From: Chuck Hill <email@hidden>
- Date: Fri, 16 Apr 2004 07:26:03 -0700
That is a database deadlock not an EOF deadlock. Check the isolation
level you are using when connecting to the database.
Chuck
On Apr 16, 2004, at 6:32 AM, email@hidden wrote:
Hello all,
I got sometimes a strange error when deleting an EOF object. All my
Editing Contexts are locked/unlocked but even with this precaution I
got the below error ( Oracle error ORA-00060: deadlock detected while
waiting for resource).
{
EOEditingContext ec = new EOEditingContext();
... lock ec
object =
ec.faultForGlobalID(loan.editingContext().globalIDForObject(loan),
ec);
object.setLock(null);
ec.deleteObject(lock);
ec.saveChanges();
... unlock ec
ec.dispose();
}
7 instances are running on the same server OS X 10.2.8 with WO 5.2.1
and Oracle 8 running on AIX server.
Any idea or suggestion how to avoid this error?
Regards,
Orlando
-------------------------------------
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "DELETE
FROM loan_lock WHERE id = ?" withBindings: 1:163090(id)>:
ORA-00060: deadlock detected while waiting for resource
stack trace:
at
com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContext
InformationAdded(EODatabaseContext.java:4658)
at
com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseCont
ext.java:6365)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingC
ontext(EOObjectStoreCoordinator.java:411)
at
com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.
java:3128)
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.