Hi,
This seems to be more of a DBMS problem than an EJB problem as I also faced this
"dead locking" problem while sending concurrent txns from an ODBC application.
I tried with both ORACLE and SQL SERVER and in both the cases, this deadlocking
problem was cropping up.
I was using "SERIALIZED" as my "transaction isolation level". Then I switched
over to "Read_Commited" and the deadlocking was considerably reduced.
I think "SERIALIZED" is the default isolation level is WebLogic.
Why not you try setting "Read Commited" as your "transaction isolation level" in
your "weblogic-ejb-jar.xml".
regards,
murty
> -----Original Message-----
> From: Yesudason Paulraj [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, January 21, 2001 10:53 AM
> To: [EMAIL PROTECTED]
> Subject: How to set Container transactions
>
> Dear friends,
> I am facing a problem related to the EJB Transactions in my project.
> Let me give a brief introduction about what I have and I am trying to do.
> we have 20 entity beans and an session bean. All the entity bean methods are
> wrapped within the session bean to provide meaningful business methods for the
> clients. I have 18 methods in the session bean and out of 18 , 11 methods are
> only read operation ( Like retriving result from the DB for some queries). Now
> the problem is that , I have a very big DB and obviuosly it takes some time
> for the query.But the write operations work very fast( because creating 2-5
> records in some tables).
>
> But I have set <trans-attribute> (Trasaction attribute) for all the methods in
> the session bean that "RequiresNew" and all the remote methods in the
> EntityBeans that "Required".
>
> Problem is , I am getting the primaryKeyLockedException frequently than
> expected. I am sure this is because of some problems in setting the
> transaction attribute for the Session bean methods.
>
> Questions are :
>
> What transactional attribute I have to set for the Entity EJB's remote
> methods?
>
> I am sure the write operations in the session bean definitely needs a new
> transaction.
> What sort of trasactional-attribute I have to specify in the Read methods
> (Query methods) in the session beans. Now as I have given "RequiresNew" for
> this methods also ,it locks the rows when it reads some data so many times I
> am getting the "PrimaryKeyLocked" exception.(I guess)
>
> I am using WLS5.1 on win2k.
> Hope I will get a confidence boosting answer.
>
> Regards
> Yesudason
>
> ===========================================================================
> 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".
===========================================================================
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".
