0 Replies Latest reply on Dec 2, 2001 2:53 PM by oezcan74

    XAException: tx=XidImpl [FormatId=257, GlobalId=www//1868, B

    oezcan74

      Hi,
      I deployed one CMP EJB with jboss, after a while I get the following exception and the connections in the pool are not recycled. I defined MaxSize=30 for the conn. pool. Connections are used by the application as one can see in the output:

      [PostgresDB] Pool PostgresDB [1/2/30] gave out pooled object: org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@24f
      [PostgresDB] Pool PostgresDB [0/2/30] returned object org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@24f to the pool.


      After this exception connections are not returned to the poll. If the limit 30 is reached, the server stops accepting connections from outside.... What could be the problem...?



      [community_account] XAException: tx=XidImpl [FormatId=257, GlobalId=www//1868, BranchQual=] errorCode=XAER_NOTA
      [community_account] javax.transaction.xa.XAException
      [community_account] at org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl.start(Compiled Code)@be060c60
      [community_account] at org.jboss.tm.TxCapsule.startResource(Compiled Code)@be060a50
      [community_account] at org.jboss.tm.TxCapsule.enlistResource(Compiled Code)@be06001c
      [community_account] at org.jboss.tm.TransactionImpl.enlistResource(Compiled Code)@bdeefb70
      [community_account] at org.jboss.pool.jdbc.xa.XAConnectionFactory.prepareObject(Compiled Code)@bd2d21d0
      [community_account] at org.jboss.pool.ObjectPool.getObject(Compiled Code)@bd06eb10
      [community_account] at org.jboss.pool.ObjectPool.getObject(Compiled Code)@bd06ea80
      [community_account] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Compiled Code)@bd06e9f0
      [community_account] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection(Compiled Code)@bdde9660
      [community_account] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(Compiled Code)@bdeef8c0
      [community_account] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(Compiled Code)@bdeef6d0
      [community_account] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(Compiled Code)@bdeef5b0
      [community_account] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand.execute(Compiled Code)@bdeef3e0
      [community_account] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntity(Compiled Code)@bdeef370
      [community_account] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(Compiled Code)@bdeef1a0
      [community_account] at org.jboss.ejb.EntityContainer.find(Compiled Code)@bdeeee90
      [community_account] at java.lang.reflect.Method.invoke(Native Method)@bce4096e
      [community_account] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(Compiled Code)@bdeee7a0
      [community_account] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(Compiled Code)@bdeee420
      [community_account] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(Compiled Code)@bdeedbb0
      [community_account] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(Compiled Code)@bdeedad0
      [community_account] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(Compiled Code)@bdeed820
      [community_account] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Compiled Code)@bdeeb660
      [community_account] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(Compiled Code)@bdeeb5d0
      [community_account] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Compiled Code)@bdeeaf50
      [community_account] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(Compiled Code)@bdeeaa10
      [community_account] at org.jboss.ejb.EntityContainer.invokeHome(Compiled Code)@bdeea9a0
      [community_account] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(Compiled Code)@bdeea600
      [community_account] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(Compiled Code)@bde02a40
      [community_account] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(Compiled Code)@bde02630
      [community_account] at $Proxy7.findByusername_lowercase(Compiled Code)@bd2504d0
      [community_account] at smart.community.common.communityaccount.CommunityAccountBean.ejbCreate(Compiled Code)@be0a14b0
      [PostgresDB] Resource 'org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl@701d' enlisted for 'org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@6fa5'.
      [PostgresDB] Pool PostgresDB [14/15/30] gave out pooled object: org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@6fa5
      [community_account] XAException: tx=XidImpl [FormatId=257, GlobalId=www//1867, BranchQual=] errorCode=XAER_NOTA