4 Replies Latest reply on May 11, 2004 1:02 AM by tkvarenes

    JBossLocalXAException

    tkvarenes Newbie

      Hello!
      I'm having problem with inserting of data into my MS SQL 2000 database. I see that several others have had similar problems, but I haven't solve mine by looking at the forum, so here goes...

      We are using JBoss 3.2.3 and MS SQL 2000. In the test environment everything works fine, but when moving to the production environment we get the excpetion shown below. The production environment should have the same set up as the test environment, I think... I think the exception occures when inserting in tables that have a one/zero to many relation to other tables. (The relations has not been set up in the database)

      If we make the application on the production server use the database on the database server in the test environment, everyting works fine. If we make the test application use the database on the production server, it fails. So it seams to be the SQL 2000 server in the production environment that is missing something(?)

      We are using the Inet Merlia JDBC Driver for Microsoft SQL Server Databases.

      Any ideas?

      Regards Trond Kvarenes



      The exception:

      2004-05-07 08:20:22,107 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException in method: public abstract tcms.data.trim.actors.CompanyValue tcms.facade.ActorsFacade.insertCompany(tcms.data.trim.actors.CompanyValue) throws tcms.util.TcmsApplicationException,java.rmi.RemoteException, causedBy:
      org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=cphjlapp//69, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=cphjlapp//69, BranchQual=1])
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:413)
      at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:398)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      at org.jboss.ejb.Container.invoke(Container.java:700)
      at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
      at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
      at $Proxy589.insertCompany(Unknown Source)
      at tcms.service.ActorsEJBDelegate.insertCompany(ActorsEJBDelegate.java:292)
      at com.tcms.refdata.CompanyExecute.doSave(CompanyExecute.java:123)
      at com.tcms.refdata.CompanyAction.perform(CompanyAction.java:78)
      at org.apache.struts.action.Action.execute(Action.java:420)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
      at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:536)
      Caused by: org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=cphjlapp//69, BranchQual=1]
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:827)
      at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1664)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:403)
      ... 73 more

        • 1. Re: JBossLocalXAException
          Adrian Brock Master

          Can you post the TRACE logging mentioned in the "READ THIS FIRST"

          • 2. Re: JBossLocalXAException
            tkvarenes Newbie

            This should be the full trace:

            2004-05-10 15:29:20,740 DEBUG [tcms.facade.ActorsFacadeSession] insertCompany({comId=null comType=CUS comArea= comCode=ttt comName=ttt comAddress= comPhoneNo= comFaxNo= comEmailAddress= comUrlAddress= comTelexNo=null comTermsOfPayment=null comCustomsProcedureNo=null comBankAccountNo=null comPostAccountNo=null comDescription=null})
            2004-05-10 15:29:20,740 DEBUG [tcms.data.trim.actors.CompanyCMP$Proxy] ejbCreate()
            2004-05-10 15:29:20,786 DEBUG [tcms.util.TcmsApplicationException]
            ErrorCode: 1.01.0002
            Arguments:
            javax.ejb.CreateException: Expected one affected row but update returned0 for id=null
            2004-05-10 15:29:20,880 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=] errorCode=XA_UNKNOWN(0)
            org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)))
            at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:755)
            at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1593)
            at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:375)
            at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:398)
            at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277)
            at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
            at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
            at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
            at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
            at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
            at org.jboss.ejb.Container.invoke(Container.java:700)
            at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
            at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
            at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
            at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
            at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
            at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
            at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
            at $Proxy589.insertCompany(Unknown Source)
            at tcms.service.ActorsEJBDelegate.insertCompany(ActorsEJBDelegate.java:292)
            at com.tcms.refdata.CompanyExecute.doSave(CompanyExecute.java:123)
            at com.tcms.refdata.CompanyAction.perform(CompanyAction.java:78)
            at org.apache.struts.action.Action.execute(Action.java:420)
            at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
            at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
            at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
            at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
            at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
            at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
            at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
            at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
            at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
            at java.lang.Thread.run(Thread.java:536)
            Caused by: org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: [TDS Driver]Connection was closed from the SQL Server site or network at header (0))
            at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:546)
            at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:97)
            at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:748)
            ... 75 more
            Caused by: java.sql.SQLException: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)
            at com.inet.tds.TdsDriver.a(Unknown Source)
            at com.inet.tds.a.a(Unknown Source)
            at com.inet.tds.a.a(Unknown Source)
            at com.inet.tds.a.a(Unknown Source)
            at com.inet.tds.a.commit(Unknown Source)
            at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:93)
            ... 76 more
            2004-05-10 15:29:20,896 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=] errorCode=XA_UNKNOWN(0)
            org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=1]
            at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:827)
            at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1664)
            at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:403)
            at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:398)
            at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277)
            at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
            at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
            at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
            at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
            at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
            at org.jboss.ejb.Container.invoke(Container.java:700)
            at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
            at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
            at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
            at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
            at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
            at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
            at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
            at $Proxy589.insertCompany(Unknown Source)
            at tcms.service.ActorsEJBDelegate.insertCompany(ActorsEJBDelegate.java:292)
            at com.tcms.refdata.CompanyExecute.doSave(CompanyExecute.java:123)
            at com.tcms.refdata.CompanyAction.perform(CompanyAction.java:78)
            at org.apache.struts.action.Action.execute(Action.java:420)
            at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
            at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
            at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
            at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
            at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
            at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
            at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
            at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
            at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
            at java.lang.Thread.run(Thread.java:536)
            2004-05-10 15:29:20,896 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException in method: public abstract tcms.data.trim.actors.CompanyValue tcms.facade.ActorsFacade.insertCompany(tcms.data.trim.actors.CompanyValue) throws tcms.util.TcmsApplicationException,java.rmi.RemoteException, causedBy:
            org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=1])
            at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:413)
            at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:398)
            at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277)
            at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
            at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
            at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
            at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
            at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
            at org.jboss.ejb.Container.invoke(Container.java:700)
            at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
            at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
            at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
            at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
            at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
            at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
            at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
            at $Proxy589.insertCompany(Unknown Source)
            at tcms.service.ActorsEJBDelegate.insertCompany(ActorsEJBDelegate.java:292)
            at com.tcms.refdata.CompanyExecute.doSave(CompanyExecute.java:123)
            at com.tcms.refdata.CompanyAction.perform(CompanyAction.java:78)
            at org.apache.struts.action.Action.execute(Action.java:420)
            at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
            at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
            at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
            at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
            at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
            at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
            at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
            at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
            at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
            at java.lang.Thread.run(Thread.java:536)
            Caused by: org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=1]
            at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionManager.java:827)
            at org.jboss.tm.TransactionImpl.rollbackResources(TransactionImpl.java:1664)
            at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:403)
            ... 73 more
            2004-05-10 15:29:20,896 DEBUG [tcms.util.TcmsApplicationException]
            ErrorCode: 9.00.0000
            Arguments:
            org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=1])
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.tiles.TilesRequestProcessor] processForwardConfig(refCompany, false)
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.RequestUtils] Get module name for path /refdata/tabsAction.do
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.RequestUtils] Module name found: default
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.action.RequestProcessor] Processing a 'POST' for path '/refdata/tabsAction'
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.action.RequestProcessor] Looking for Action instance for class com.tcms.refdata.TabsAction
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.action.RequestProcessor] Returning existing Action instance
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.tiles.TilesRequestProcessor] uri=/jsp/refdata/tabList.jsp doInclude=false
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.PropertyMessageResources] getMessage(en_US,tab.company)
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.PropertyMessageResources] loadLocale(en_US)
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.PropertyMessageResources] getMessage(en_US,tab.dep)
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.PropertyMessageResources] loadLocale(en_US)
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.PropertyMessageResources] getMessage(en_US,tab.contacts)
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.util.PropertyMessageResources] loadLocale(en_US)
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.taglib.tiles.InsertTag] insert page='/jsp/refdata/companyEdit.jsp'.
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.server.JkCoyoteHandler] COMMIT
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.server.JkCoyoteHandler] COMMIT sending headers org.apache.coyote.Response@1a8da44 === MimeHeaders ===

            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.common.ChannelSocket] send() 60 4
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.server.JkCoyoteHandler] doWrite 0 6108 0
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.common.ChannelSocket] send() 6116 3
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.server.JkCoyoteHandler] CLIENT_FLUSH
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.server.JkCoyoteHandler] CLIENT_FLUSH
            2004-05-10 15:29:20,911 DEBUG [org.apache.struts.tiles.TilesRequestProcessor] 'refCompany' - processed as definition
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.server.JkCoyoteHandler] doWrite 0 5817 0
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.common.ChannelSocket] send() 5825 3
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.server.JkCoyoteHandler] CLOSE
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.common.ChannelSocket] send() 6 5
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.REQ_TIME] Time pre=0/ service=375 -1 /tcms/refdata/companyEdit.do
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.common.HandlerRequest] Invoke returned 0
            2004-05-10 15:29:20,911 DEBUG [org.apache.jk.common.ChannelSocket] receive()
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.ChannelSocket] read() [B@1210267 8192 0 4 = 4
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.MsgAjp] Received 488 18
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.ChannelSocket] read() [B@1210267 8192 4 488 = 488
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.ChannelSocket] Call next 0 org.apache.jk.common.HandlerRequest@c70b0d
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.HandlerRequest] Handling 2
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.HandlerRequest] R( /tcms/jsp/error.jsp)
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.HandlerRequest] Calling next container org.apache.jk.server.JkCoyoteHandler
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.server.JkCoyoteHandler] Invoke R( /tcms/jsp/error.jsp) org.apache.coyote.Response@1a8da44 /tcms/jsp/error.jsp
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.server.JkCoyoteHandler] ACK
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.server.JkCoyoteHandler] COMMIT
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.server.JkCoyoteHandler] COMMIT sending headers org.apache.coyote.Response@1a8da44 === MimeHeaders ===
            Pragma = No-cache
            Cache-Control = no-cache
            Expires = Thu, 01 Jan 1970 00:00:00 GMT

            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.ChannelSocket] send() 173 4
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.server.JkCoyoteHandler] doWrite 0 1687 0
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.ChannelSocket] send() 1695 3
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.server.JkCoyoteHandler] CLOSE
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.ChannelSocket] send() 6 5
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.REQ_TIME] Time pre=0/ service=0 1687 /tcms/jsp/error.jsp
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.HandlerRequest] Invoke returned 0
            2004-05-10 15:29:20,990 DEBUG [org.apache.jk.common.ChannelSocket] receive()

            • 3. Re: JBossLocalXAException
              Adrian Brock Master

              Seems pretty obvious to me, either your database or network closed the connection:
              Connection was closed from the SQL Server site or network at header (0)))

              • 4. Re: JBossLocalXAException
                tkvarenes Newbie

                Yes, the connection was closed. I'm trying to find out why?
                Can the warning about XA_UNKNOWN tell me anything? Could it be that the MS SQL server does not supprot the XA protocol? Does anyone know if that is something one can "turn on/off" in the MS SQL server? Are there any other hint in the stack trace, of why the connection was closed?


                -Trond