Problem with transaction in Jboss (programatic model)

[michal_szymanski]

I try to use  programatic model transaction for Axis2 Webservice, for this we deployed Axis2 and our services on Jboss 5.1. I created XA datasource and without 'begin'  all transaction are autocommited and it works ok. But when I put 
UserTransaction.userTransaction().begin();  I've got following error:

14:32:57,250 INFO  [STDOUT] [ERROR] loader constraint violation: loader (instance of org/apache/axis2/deployment/DeploymentCl
assLoader) previously initiated loading for a different type with name "javax/transaction/UserTransaction"
java.lang.reflect.InvocationTargetException

Should I switch off  local transaction or maybe there is other error?
Below part of my program.

import java.sql.Connection;
    import java.sql.SQLException;
    import java.sql.Statement;

    import javax.naming.InitialContext;
    import javax.naming.NamingException;
    import javax.sql.DataSource;
    import javax.transaction.HeuristicMixedException;
    import javax.transaction.HeuristicRollbackException;
    import javax.transaction.NotSupportedException;
    import javax.transaction.RollbackException;
    import javax.transaction.SystemException;
    import org.apache.log4j.Logger;
    import com.arjuna.ats.jta.UserTransaction;

    public CreateServiceResponse createService(String token, String serviceName, String serviceType, String consolePassword) {

        InitialContext dic;
        try {
            dic = new InitialContext();
            DataSource dsUms = (DataSource) dic.lookup("java:jdbc/UMSDbDS");           
            Connection conUms = null;
            conUms = dsUms.getConnection();
           
            try {
                UserTransaction.userTransaction().begin();        /* EXCEPTION  HAPPENS HERE !! */
            } catch (NotSupportedException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (SystemException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
               
            Statement stmtUms = conUms.createStatement();;
            String sql = "update dict.cfg_dictionary set description='DUPAUMS_1'";
            stmtUms.executeUpdate(sql);

Michal Szymanski

http://blog.szymanskich.net

http://techblog.freeconet.pl

[michal_szymanski]

I forgot to add, we use prgramatic model of transaction because we use several daasources in one transaction. In our example I present operation only in one datasource for simplicity.

[mmusgrov]

Do you get the same problem if you lookup UserTransaction via JNDI?

[michal_szymanski]

I changed from:

UserTransaction.userTransaction().begin();    

to

UserTransaction utx = null;

utx = (javax.transaction.UserTransaction) dic.lookup("UserTransaction");
                utx.begin();

and I changed
    import com.arjuna.ats.jta.UserTransaction;

to

   import javax.transaction.UserTransaction;

During runtime I've got:

14:54:55,609 INFO  [STDOUT] [ERROR] org.jboss.tm.usertx.client.ServerVMClientUserTransaction cannot be cast to javax.transact
ion.UserTransaction

[jhalliday]

stop packaging the jta api jar with your app, it's supplied by the server.

[michal_szymanski]

To be honest I cannot find jta.jar in my application. In our service file .aar thera are no jar files and in axis2.jar  there is also no jta.jar

[michal_szymanski]

I've found problem there was no jta.jar but it was:

geronimo-jta_1.1_spec-1.1.zip

  somebody from Axis changed name of jar. It looks that transaction works as expected. Thank for your help!

Michal Szymanskich

http://techblog.szymanskich.net