Hi Mahindrakar,
Thanks for your response.
Yes, I agree that setting Isolation Levels at method level would give better performance than setting it at Bean Level.You can have more restrictive isolation levels at method level, that
at a Bean Level - taking the advantage of method level declared isolations overiding bean level declared isolations -- Correct??
I think, you can set Isolation Levels also for CMT Entity/Session Beans.The EJB Specs 2.0 mentions about this to be managed by data access classes provided by Persistence managed provider's tools - which needs to be in sync with that provided by what your DB Resource Manager supports.I presume the Specs wants to highlight tools like that shown in
Ed Roman's book on Page 285 Now, given a choice of setting isolation levels, which one should we prefer from the performance prospective?Will setting isolation levels in the middle-tier hamper the performance?Should the DB be allowed to take care of the isolation levels, as it is closer to the data?
Please advise.
Regards,
Sandeep
- Sun Certified Programmer for Java 2 Platform Scored 93 per cent
- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java Scored 56 out of 59
- IBM Enterprise Connectivity with J2EE Scored 72 per cent
- Enterprise Development on the Oracle Internet Platform Scored 44 out of 56
[This message has been edited by Desai Sandeep (edited May 09, 2001).]