1 Reply Latest reply on Aug 26, 2004 10:43 AM by adrian.brock

    Fiberbird XATransaction error: Could not enlist in transacti

    lsalves

      I'm having a problem with XATransaction on Firebird JDBC/JCA.
      I saw that some people have had the same problem with Oracle.

      My program executes de follow steps:

      GET USER_TRANSACTION
      BEGIN TRANSACTION
      GET CONNECTION VIA JDBC
      EXECUTE A QUERY
      CLOSE CONNECTION
      OPEN A HIBERNATE SESSION
      EXECUTE A INSERT VIA HIBERNATE SESSION
      ERROR !!!!!!!!!!!

      The trace is below:

      15:13:30,795 INFO [TxConnectionManager] Could not enlist in transaction on entering meta-aware object!
      javax.transaction.SystemException: enlistResource failed
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:456)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:79)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
      at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
      at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
      at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
      at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
      at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
      at net.sf.hibernate.loader.Loader.list(Loader.java:941)
      at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
      at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1633)
      at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1623)
      at br.com.b2brasil.redefacil.model.CacheRelatoriosModel.limpar(CacheRelatoriosModel.java:102)
      .....
      15:13:30,795 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: HY000
      15:13:30,795 ERROR [JDBCExceptionReporter] Problem getting connection: javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed
      15:13:30,795 ERROR [JDBCExceptionReporter] Cannot open connection
      org.firebirdsql.jdbc.FBSQLException: Problem getting connection: javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed
      at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:82)
      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
      at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
      at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
      at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
      at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
      at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
      at net.sf.hibernate.loader.Loader.list(Loader.java:941)
      at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
      .....

      Can some help me, please?

      Thanks