4 Replies Latest reply on Aug 6, 2003 12:34 AM by ghosttrain

    Whether the jboss4.00alpha support the xa datasource?

    xiaoyi

      And i want to know whether the jboss4.00alpha support the XA datasource.
      And how to configure the oracle-ds-xa.xml and db2-ds-xa.xml
      And how to write the codes to update the xa datasource?
      Is below write?
      XADataSource ds = (XADataSource)(new InitialContext()).lookup("java:/OracleDS");
      XAConnection con = ds.getXAConnection();
      Connection c=con.getConnection();
      I am looking forward your help!
      thanks!

        • 1. Re: Whether the jboss4.00alpha support the xa datasource?
          xiaoyi

          And i configure the db2-xa-ds.xml as:

          <xa-tx-datasource>
          <jndi-name>DB2XADS</jndi-name>

          <xa-datasource-class>COM.ibm.db2.jdbc.app.DB2XAResource</xa-datasource-class>
          <xa-datasource-property name="DatabaseName">account</xa-datasource-property>
          <xa-datasource-property name="User">db2</xa-datasource-property>
          <xa-datasource-property name="Password">db2</xa-datasource-property>
          </xa-tx-datasource>

          but the wrong message is:
          DB2XADS not bound
          i don't know the reason.Coule you help me?

          • 2. Re: Whether the jboss4.00alpha support the xa datasource?
            xiaoyi

            who can tell me whether the jboss4.00 support the xa configure and transaction?
            it seems that it only supports local transaction.
            when i configure the datasource as xa .
            the wrong message is coming.
            Who have experimented xa transaction successfully?

            • 3. Re: Whether the jboss4.00alpha support the xa datasource?
              xiaoyi

              why nobody answers me?i will wait you online!

              • 4. Re: Whether the jboss4.00alpha support the xa datasource?
                ghosttrain

                Your configuration is same as mine. But i use it in jboss-3.2.1.
                It works well with CMP. But when i use it to call a stored procedure in db2, it fails. Only local-tx support stored procedure.

                <xa-datasource>
                <jndi-name>LyreXADS</jndi-name>
                <xa-datasource-class>COM.ibm.db2.jdbc.DB2XADataSource</xa-datasource-class>
                <xa-datasource-property name="DatabaseName">lyre</xa-datasource-property>
                <xa-datasource-property name="User">goncha</xa-datasource-property>
                <xa-datasource-property name="Password">811128</xa-datasource-property>
                <security-domain>LyreXADBRealm</security-domain>
                </xa-datasource>