4 Replies Latest reply on Jun 4, 2014 1:24 PM by x046866x

    Problem with XA connections

    x046866x

      Folks,

       

      I am getting the same error on all my XA connections.  The configuration screens all seem to work and the connection is confirmed as valid, but my server.log is littered with:

      2014-06-04 00:00:18,329 ERROR [org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl] (Periodic Recovery) IJ000906: Error during crash recovery: java:/jdbc/CTMS-DS-XA (Could not create connection): javax.resource.ResourceException: Could not create connection

        at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:461)

        at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:398)

        at org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.open(XAResourceRecoveryImpl.java:343)

        at org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.getXAResources(XAResourceRecoveryImpl.java:170)

        at com.arjuna.ats.internal.jbossatx.jta.XAResourceRecoveryHelperWrapper.getXAResources(XAResourceRecoveryHelperWrapper.java:51) [narayana-jts-integration-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.resourceInitiatedRecoveryForRecoveryHelpers(XARecoveryModule.java:516) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:182) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:743) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]

      Caused by: java.lang.IllegalStateException

        at org.jboss.msc.value.InjectedValue.getValue(InjectedValue.java:47)

        at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.driverClassLoader(AbstractDataSourceService.java:246)

        at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.access$200(AbstractDataSourceService.java:93)

        at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer$1.getClassLoader(AbstractDataSourceService.java:396)

        at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:581)

        at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:444)

        ... 8 more

       

      I'm relatively sure it is a configuration issue, but not sure where to look.  Can anyone help?

        • 1. Re: Problem with XA connections
          ctomc

          what jdbc driver / database? mysql?

           

          also if not already can you try with WildFly 8.1.0.Final

          1 of 1 people found this helpful
          • 2. Re: Problem with XA connections
            x046866x

            Oracle: oracle.jdbc.xa.client.OracleXADataSource from ojdbc6.jar

             

             

            I may be able to try that a bit later today....is that a known fix space?

            • 3. Re: Problem with XA connections
              lafr

              I'm using Oracle-XA connections without problems.

              Another thing worth updating might be the JDBC driver. I'm using the latest ojdbc7.jar (ojdbc7.jar for Java 7 and later) version 12.1. here.

               

              What does your xa-datasource definition look like?

              • 4. Re: Problem with XA connections
                x046866x

                I actually updated to 8.1.0 and they seem to have gone away.  I may use ojdbc7.jar also (in 8.0.0) to see if that helps.

                 

                Configuration is standard fare using oracle.jdbc.xa.client.OracleXADataSource class in the ojdbc6.jar.  URL property shows the connection URL for the DB.