0 Replies Latest reply on Jul 17, 2007 4:29 AM by baz

SEAM and XA datasources

baz Jul 17, 2007 4:29 AM

Hello,
Can seam manage XA Datasources?
I have configured one datasource for oracle and every time it is accessed i get

08:59:38,680 ERROR [XAManagedConnectionFactory] Start transaction failed for org.jboss.resource.adap
ter.jdbc.xa.XAManagedConnection@14c9bfb
08:59:38,680 WARN [TxConnectionManager] Connection error occured: org.jboss.resource.connectionmana
ger.TxConnectionManager$TxConnectionEventListener@13a7cd4[state=NORMAL mc=org.jboss.resource.adapter
.jdbc.xa.XAManagedConnection@14c9bfb handles=0 lastUse=1184655578649 permit=true trackByTx=true mcp=
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@94a25c context=org.jboss.res
ource.connectionmanager.InternalManagedConnectionPool@2f4f8b xaResource=org.jboss.resource.connectio
nmanager.xa.JcaXAResourceWrapper@d9794b txSync=null]
oracle.jdbc.xa.OracleXAException
 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157)
 at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295)
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:121)
 at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.start(JcaXAResourceWrapper.java:113
)
 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionIm
ple.java:701)
 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionIm
ple.java:446)
 at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSy
nchronization.enlist(TxConnectionManager.java:773)
 at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConn
ectionManager.java:564)
 at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnecti
onManager.java:337)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConne
ctionManager2.java:518)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionMan
ager2.java:399)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConne
ction(BaseConnectionManager2.java:842)
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
 at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSour
ceConnectionProvider.java:47)
 at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
 at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
 at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)

but the schema vaildation succeds. So Jboss must be able to access the db. But everytime a transaction comes in play the above error occurs.
I do need the XA datasource for oracle in order to use LRCO.

my original problem is posted here:
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064876

Ciao,
Carsten