In our app, occasionally database deadlocks are going to happen (sybase
page locks).

I need to be able to detect them and retry a certain number of times.

Unfortunately when using bean managed peristence, I have sql in several
methods eligible for deadlock.

I could write some logic something like:

while ((retryCount < maxRetries) && (!success))
{
try {
       executeSql
       success = true
catch(SqlException sqe)
{
 retryCount = retryCount + 1
}
}

The problem is I have to do this , in ejbLoad, ejbCreate, ejbStore, and
ejbRemove + possibly some finders for every bean.
This seems ugly.

Any ideas of how I could put this in a framework? (btw Im using Weblogic
App Server)

thanks
Joel

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to