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: Jonathan Rochkind <email@hidden>
- Date: Mon, 19 Apr 2004 10:47:52 -0500
I use MS SQL Server 7, not Oracle, myself. With MS SQL Server, it is
unavoidable to sometimes get a 'deadlock' exception. I discovered
this when I got such an exception, and looked in the documentation
for MS SQL Server for what it meant, which explained it fairly well
and now I understand why it's unavoidable to sometimes encounter such
an error.
Perhaps looking in the Oracle documentation for information about
deadlocks would be helpful to you.
--Jonathan
At 3:32 PM +0200 4/16/04, 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._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4658)
at
com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6365)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(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.