[teiid-issues] [JBoss JIRA] Updated: (TEIID-559) MMSQLException querying with SQL Server XA Connector in Teiid Designer
Barry LaFond (JIRA)
jira-events at lists.jboss.org
Thu May 7 10:21:47 EDT 2009
[ https://jira.jboss.org/jira/browse/TEIID-559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Barry LaFond updated TEIID-559:
-------------------------------
Summary: MMSQLException querying with SQL Server XA Connector in Teiid Designer (was: MMSQLException querying with SQL Server XA Connector)
Environment: Teiid Designer Kit: teiid_designer_6.0.0.v20090427_SNAPSHOT.zip
Description:
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.UpdateProduct where Instr_ID = 'PRD01200'
8) Executing the query should produce above Exception
was:
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)
> 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: 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.UpdateProduct where Instr_ID = 'PRD01200'
> 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
More information about the teiid-issues
mailing list