4 Replies Latest reply on Dec 1, 2004 8:17 PM by giantgone

    I have trouble on JBoss JTA with OracleXADs and JMSQueue

    giantgone Newbie

      I have trouble on JBoss JTA with OracleXADs and JMSQueue
      (I think that OracleDriver is not available prepare phase of 2PC)

      Env.
      JBOSS: 3.2.7RC1
      JMS: Jboss Default JmsXA
      ORACLE: 8i
      JdbcDriver: Oracle10g Driver
      ....


      Hi.
      I am poor at English.

      My Program is 2 DbConnections and 1 JmsSession on Controled?Transaction by JTA .
      When Commiting , the problem occurred.

      The problem is that ORACLE does not lock SELECT Query, although the prepare stage has finished.

      Although MDB runs in the middle of a commitment, the query in the inside of it returns the result
      before committing.
      In this case, ORACLE should block SELECT Query until COMMIT finishes.

      please advice to me.

      log here .
      http://www.geocities.jp/giantgone2001/log.html


      I'm sorry,I wrote this question to JTA Forum yesterday
      and it was deleted immediately