[teiid-issues] [JBoss JIRA] Resolved: (TEIID-559) MMSQLException querying with SQL Server XA Connector in Teiid Designer

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-559.
----------------------------------

    Resolution: Rejected


This is a problem with the setup of the SQL Server instance.

> MMSQLException querying with SQL Server XA Connector in Teiid Designer
> ----------------------------------------------------------------------
>
>                 Key: TEIID-559
>                 URL: https://jira.jboss.org/jira/browse/TEIID-559
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 6.0.0
>         Environment: Teiid Designer Kit:  teiid_designer_6.0.0.v20090427_SNAPSHOT.zip
>            Reporter: Barry LaFond
>            Assignee: Steven Hawkins
>             Fix For: 6.1.0
>
>         Attachments: E2E Update Virtual Groups Test Script.odt, UpdateVirtualGroup_MPS,zip
>
>
> 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.    
> For reference, standard SQL Server Connector URL =  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)
> To reproduce:
> 1) Install Designer:   teiid_designer_6.0.0.v20090427_SNAPSHOT.zip
> 2) Create SQL XA Connector for CustomerAcccounts and Oracle XA Connectors to Products
> 3) Open UpdatesVDB in VDB Editor
> 4) Select Execute tab and Edit connectors to bind sources to XA Connectors 
> 5) Save VDB
> 6) Select Execute VDB
> 7) In SQL Editor, paste:  DELETE FROM Updates.UpdateAccount where CustID = 'CST02000' and LastName = 'Metamatrix'
> 8) Executing the query should produce above Exception

-- 
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