Hi Can any one tell me on how to fix the following error:
Caused by: java.sql.SQLException: Remote org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware o
bject!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous wa
rnings. tx=TransactionImple < ac, BasicAction: -7235bee1:55a:4d92ce22:272 status: ActionStatus.ABORT_ONLY >); - nested throwable: (o
rg.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax
.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac,
BasicAction: -7235bee1:55a:4d92ce22:272 status: ActionStatus.ABORT_ONLY >))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:245)
... 19 more
Caused by: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -7235b
ee1:55a:4d92ce22:272 status: ActionStatus.ABORT_ONLY >
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.checkEnlisted(TxCo
nnectionManager.java:879)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:675)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:403)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:625)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:499)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.jav
a:941)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
... 20 more
Thanks,
Rakesh.
Rakesh,
We explained this once before http://community.jboss.org/message/556540
Please see this http://docs.jboss.org/teiid/7.3.0.Final/reference/en-US/html/transaction_support.html#d0e5612
Ramesh..