2 Replies Latest reply on Nov 22, 2005 2:36 AM by Sascha Kulawk

    Transaction Locking "Never" without locks, "Required" with l

    Sascha Kulawk Newbie

      I have just a little question about transaction locking.
      I have an application, which has some few write operations but on the website a lot of read operations.
      Using Standard CMP Entity Bean ends up with deadlocks on the webserver side, so I tired to use Instance per Transaction and other Entity Container.
      With Instance per Transaction the problem occures, that sometimes wrong values are saved on the write methods inside the database because of transactional caching.

      So my question is - which is the best method to use:
      1 session bean with required transactions
      1 session bean with Never transactions (for web access)
      on the same entities - which container type should be used? Do I need to use Optimistic Locking?

      Thanks a lot,
      Sascha