2 Replies Latest reply on Dec 5, 2003 11:36 AM by Joe Fraser

    mySQL/Isolation/concurrent update

    zahid14 Newbie

      I am having a entity bean which provides sequence number to its caller. It simply increments(setId(getId()+1) the number after each access but in case of concurrent access to it the multiple caller are gettting the same value. I assume, JBoss, by default provides Serialize isolation but I saw multiple threads getting the same value. It happens ONLY when multiple callers are accessing the bean, when load is less it works fine.
      I also put RequiresNew transaction but it did not help.
      Any help to make sure it provides unique number will be appreciated.

      Thanks in advance