5 Replies Latest reply on Aug 1, 2009 3:32 AM by Tim Fox

    Bridge with QOS_ONCE_AND_ONLY_ONCE

    Stuart Williamson Novice

      I am trying to configure a bridge with the quality of service set to QOS_ONCE_AND_ONLY_ONCE in JBoss Messaging 1.4.4 within JBoss AS 4.2.3. As far as I understand, for this to work I must use an XA datasource. I have therefore changed the DefaultDS to an XA one. However, this gives me problems when I try to start the server where it is attempting to create the tables:

      [main] 09:32:43,404 TRACE [org.jboss.messaging.core.impl.JDBCSupport] Executing: CREATE TABLE JBM_USER (USER_ID VARCHAR2(32) NOT NULL, PASSWD VARCHAR2(32) NOT NULL, CLIENTID VARCHAR2(128), PRIMARY KEY(USER_ID))
      [main] 09:32:43,404 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_USER (USER_ID VARCHAR2(32) NOT NULL, PASSWD VARCHAR2(32) NOT NULL, CLIENTID VARCHAR2(128), PRIMARY KEY(USER_ID))
      java.sql.SQLException: ORA-02089: COMMIT is not allowed in a subordinate session
      


      If I change the datasource to a non-XA one then the tables are created successcully but my bridge does not work. Can anyone help me please?