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

    SEAM and XA datasources

    Carsten Hoehne Master

      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