This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes BEA/Weblogic and the fly likes Isolation in Weblogic 8.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Isolation in Weblogic 8.1" Watch "Isolation in Weblogic 8.1" New topic

Isolation in Weblogic 8.1

prem karun gopal

Joined: Dec 03, 2003
Posts: 24
Dear All,
I have a problem with isolation level in weblogic.
method defined in session Bean
public Collection (int count);

What this method does is as follows
There is a table which stores the last generated value of a sequence.
So when next time a request comes for two numbers the method reads the last generated value and gives back a two numbers next in sequence to the last generated value.But when two client requests comes concurrantly every ting goes wrong.Both gets the same numbers as the next sequence,since each reads the same value of last generated number. So i set the Isolation level of the method to TRRANSACTION_SERIALIZABLE_READ_COMMITED_FOR_UPDATE.The basic idea is i want a read lock on that particular row.I tried that and it doesnt work.Still i'm getting concurrency issues in that method.
How do i do that using Weblogic 8.1 and Oracle 9.2
Can any one help in this

Best Regards

Prem Kumar.k<br />Email
subject: Isolation in Weblogic 8.1