Discussions

EJB programming & troubleshooting: Avoiding concurrent access through Beans

  1. Avoiding concurrent access through Beans (1 messages)

    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 V
  2. 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.