[teiid-issues] [JBoss JIRA] Created: (TEIID-559) MMSQLException querying with SQL Server XA Connector

[Barry LaFond (JIRA)]

MMSQLException querying with SQL Server XA Connector
----------------------------------------------------

                 Key: TEIID-559
                 URL: https://jira.jboss.org/jira/browse/TEIID-559
             Project: Teiid
          Issue Type: Bug
            Reporter: Barry LaFond
            Assignee: Steven Hawkins


E2E Update through Virtual Groups Test Script was successful with INSERT, UPDATE, DELETE through Oracle connector (Native Driver)

However updates are failing with SQL Server XA Connector.    (jdbc:sqlserver://slntdb02.mm.atl2.redhat.com:1433;databasename=customeraccounts)

com.metamatrix.jdbc.MMSQLException: Failed to enlist the XAResource in Transaction.
	at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:82)
	at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:63)
	at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:424)
	at com.metamatrix.jdbc.MMStatement.execute(MMStatement.java:326)
	at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:192)
	at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:121)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: [XATransactionException]Failed to enlist the XAResource in Transaction.
	at org.teiid.dqp.internal.transaction.TransactionServerImpl.enlist(TransactionServerImpl.java:561)
	at sun.reflect.GeneratedMethodAccessor260.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:616)
	at com.metamatrix.common.log.LogManager$1.invoke(LogManager.java:407)
	at $Proxy6.enlist(Unknown Source)
	at org.teiid.dqp.internal.datamgr.impl.SynchConnectorWorkItem.enlistResource(SynchConnectorWorkItem.java:118)
	at org.teiid.dqp.internal.datamgr.impl.SynchConnectorWorkItem.createExecution(SynchConnectorWorkItem.java:101)
	at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.process(ConnectorWorkItem.java:151)
	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
	at org.teiid.dqp.internal.datamgr.impl.SynchConnectorWorkItem.run(SynchConnectorWorkItem.java:69)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
	at java.lang.Thread.run(Thread.java:636)





-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira