0 Replies Latest reply on Sep 6, 2002 5:01 AM by Kasper Nielsen

    "locking" an entityejb

    Kasper Nielsen Newbie


      I have a problem designing a ressource allocation system.

      Lets say I have a ressource that I want people to able to reserve for a specifik amount of time.
      So for example i have a reservation table with the following structure: RessourceID, startTime, finishTime

      How do I make that there aren't 2 people reservering the same item at the same time??

      since each reservation is made in different transactions I can't make sure they aren't working on the same timespan for a specific ressource.