4 Replies Latest reply on Sep 19, 2006 10:39 AM by marklittle

    Will it involve in XA transaction if MysqlXADatasource is cr

      Can i create datasource as below and use the connection obtained from this in Distributed transaction with JTA in JBoss application server ??,
      instead of configuring in mysql-xa-ds.xml and perform jndi lookup ??



      com.mysql.jdbc.jdbc2.optional.MysqlXADataSource mysqlXADataSource
      = new com.mysql.jdbc.jdbc2.optional.MysqlXADataSource();

      mysqlXADataSource.setURL("jdbc:mysql://:3306/test");
      mysqlXADataSource.setUser("root");
      mysqlXADataSource.setPassword("test");

      Connection conn = mysqlXADataSource.getXAConnection().getConnection();


      Here my question is will this mysql datasource involve in XA transactions in JBoss application server when JTA is used to control the transactions??


      Please help me ASAP....appreciate your help

      thanks in advance