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".
