2 Replies Latest reply on Jun 12, 2007 11:44 AM by Manik Surtani

    JBossCache transaction isolation levels

    andrea ricci Newbie

      hi all,
      i am testing JBossCache (version 1.4.1.SP3) Transaction Isolation levels. For this reason i have developed a simple test application that creates 2 threads that concurrently perform local transactions. All the examples have been done with Postgres-8.2.1, and everytime i have changed JBossCache Transaction Isolation level, i have changed the corresponding one in the database.
      Thread 1: looks for a bean with primary key 1 and prints it, then sleeps for 2 seconds. when it wakes up, looks again for bean with primary key 1 and prints it.
      Thread 2: creates and persist a bean with primary key 1.
      Everytime Thread 1 starts its execution before Thread 2.

      @TransactionAttribute(TransactionAttributeType.REQUIRED)
      public void doTransaction(int id) throws Exception {
       System.out.println(id + ": start transaction");
      
       // Thread 2
       if((id % 2) == 0) {
       em.persist(new Tx(1, 0, "adapt19"));
       System.out.println(id + ": inserted 1");
       }
       // Thread 1
       else {
       Tx tx = em.find(Tx.class, 1);
       System.out.println(id + ": " + tx);
       Thread.currentThread().sleep(2000);
       tx = em.find(Tx.class, 1);
       System.out.println(id + ": " + tx);
       }
      
       System.out.println(id + ": end transaction");
      } catch(Exception e) {e.printStackTrace();}
      


      Serializable: ok
      Repeatable read: no
      1: start tx
      2: start tx
      1: null
      2: inserted 1
      2: end tx
      1: 1, 0, adapt19 [should be null]
      1: end tx
      

      Read committed: ok
      Read uncommitted: no (When trying to test this Isolation level i have inserted a delay in Thread 2 to make it commit after Thraed 1)
      1: start tx
      1: null
      2: start tx
      2: inserted 1
      1: null [shuold be 1, 0, adapt19]
      1: end tx
      2: end tx
      


      Now my question is: is there something wrong with JBossCache Transaction Isolation levels, or something wrong with my test application?

      Thank you very much
      Andrea