ORA-08177 error
1 posts in topic
Flat View  Flat View

Posted By:   Ganapathi_Balike
Posted On:   Tuesday, April 24, 2001 06:48 AM

In my application, I have a method in a stateful EJB . The trasaction attribute for this method is "REQUIRED". This method calls 5 set methods of one entity EJB and then calls 4 set methods of another entity EJB. All these set methods in entity EJBs have trasaction attribute- "REQUIRED".
When i execute this specific update functionality with one user, there is no problem. But when the same functionality is executed with more than 5 users at once, i get the following error -
ORA-08177-Can't serialize access for this transaction.
I am using Weblogic app server.
Please help.

Re: ORA-08177 error

Posted By:   Combaluzier_David  
Posted On:   Thursday, August 2, 2001 07:38 AM

This is due to your isolation level. The Entity bean which is used as well as your session bean should have TRANSACTION_SERIALIZABLE isolation level. If it is not possible (due to applicative or database limitation), catch the former exception and perform some retries. You should also catch TransactionRolledBackException. These two exceptions occure when several accesses to the same ressources are performed. The first access lock the ressource and the second one cannot do anything so it returns an exception.
About | Sitemap | Contact