EJB programming & troubleshooting: Avoiding concurrent access through Beans
Hi, I am using a Stateless Session Bean. The transaction type is set to Bean. I am using Oracle 10g (JDeveloper 18.104.22.168) 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 V
- Posted by: archna vish
- Posted on: May 22 2007 05:57 EDT
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.