-
Avoiding concurrent access through Beans (1 messages)
- Posted by: archna vish
- Posted on: May 22 2007 05:57 EDT
Hi, I am using a Stateless Session Bean. The transaction type is set to Bean. I am using Oracle 10g (JDeveloper 9.0.5.2) How can I avoid concurrent access to a single record using this bean. I tried using UserTransaction and also setting the connection transaction type to Connection.TRANSACTION_SERIALIZABLE. However I am getting "ORA-08177: can't serialize access for this transaction". How can concurrent access/dirty reads be avoided? Thanks, Archana VThreaded Messages (1)
- Re: Avoiding concurrent access through Beans by Biswa Das on May 23 2007 03:10 EDT
-
Re: Avoiding concurrent access through Beans[ Go to top ]
- Posted by: Biswa Das
- Posted on: May 23 2007 03:10 EDT
- in response to archna vish
Your driver may not be supporting the isolation level TRANSACTION_SERIZABLE. If you are not using entity beans, set the database transaction for the table/record to read committed. This setting need to be done at Oracle not in ejb tier.