• Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB isolation level

 
lavanya Ananth
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

I have a question on EJB isolation level TRANSACTION_READ_COMMITTED_FOR_UPDATE. My EJB has this isolation level and the oracle database i am connecting to has a default isolation level of READ_COMMITTED.

This EJB is used to generate a sequence. I sometimes encounter concurrency problems in that when two users request for a sequence number for the same TABLE , it ends up giving the same sequence number to both the calls.

How do I reslove this issue?

I would appreciate any inputs .

Thanks
Lavanya
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!