This is an exception that we get periodically. It seems to be a result of a
long running transaction. Anybody have any idea? We are running 5.1 with sp
11
Thanks
Gaurav
2002-03-27 23:32:39,315 ERROR ABCSessionBean.execute - The XXX ABC
encountered an unexpected problem while processing this request.
java.rmi.UnexpectedException: Unexpected exception in
com.xyz.chakde.yyy.session.RequestSessionBean.execute():
java.rmi.UnexpectedException: Unexpected exception in
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypeBean.getName():
java.sql.SQLException: Transaction timed out, rolled back and returned the
connection to the pool
at weblogic.jdbcbase.jts.Driver.connect(Driver.java:263)
at
weblogic.cmp.rdbms.PSRdbms_Base.getConnection(PSRdbms_Base.java:89)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypePSWebLogic_CMP_RDB
MS.refresh(EquipmentTypePSWebLogic_CMP_RDBMS.java:250)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypePSWebLogic_CMP_RDB
MS.load(EquipmentTypePSWebLogic_CMP_RDBMS.java:232)
at
weblogic.ejb.internal.EntityEJBContext.load(EntityEJBContext.java:153)
at
weblogic.ejb.internal.EntityEJBContext.afterBegin(EntityEJBContext.java:214)
at
weblogic.ejb.internal.StatefulEJBObject.getContextForInvoke(StatefulEJBObjec
t.java:162)
at
weblogic.ejb.internal.BaseEJBObject.preInvoke(BaseEJBObject.java:445)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypeBeanEOImpl.getName
(EquipmentTypeBeanEOImpl.java:189)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypeEJBAdaptor.getName
(EquipmentTypeEJBAdaptor.java:90)
at
com.xyz.chakde.yyy.request.EventRequest.buildNotify(EventRequest.java:252)
at
com.xyz.chakde.yyy.request.EventRequest.buildNotify(EventRequest.java:211)
at
com.xyz.chakde.yyy.request.UpdateContainerTripRequest.executeEvent(UpdateCon
tainerTripRequest.java:108)
at
com.xyz.chakde.yyy.request.EventRequest.execute(EventRequest.java:92)
at
com.xyz.chakde.yyy.session.RequestSessionBean.execute(RequestSessionBean.jav
a:57)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl.execute(RequestSessionBe
anEOImpl.java:56)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl_ServiceStub.execute(Requ
estSessionBeanEOImpl_ServiceStub.java:220)
at
com.xyz.chakde.yyy.session.ABCSessionBean.execute(ABCSessionBean.java:71)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl.execute(ABCSessionBeanEOImpl
.java:146)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl_ServiceStub.execute(ABCSessi
onBeanEOImpl_ServiceStub.java:263)
at com.xyz.chakde.yyy.session.ABCGateway.execute(ABCGateway.java:67)
at
com.xyz.chakde.yyy.request.BatchRequest.execute(BatchRequest.java:49)
at
com.xyz.chakde.yyy.session.RequestSessionBean.execute(RequestSessionBean.jav
a:57)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl.execute(RequestSessionBe
anEOImpl.java:56)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl_ServiceStub.execute(Requ
estSessionBeanEOImpl_ServiceStub.java:220)
at
com.xyz.chakde.yyy.session.ABCSessionBean.execute(ABCSessionBean.java:71)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl.execute(ABCSessionBeanEOImpl
.java:146)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl_ServiceStub.execute(ABCSessi
onBeanEOImpl_ServiceStub.java:263)
at com.xyz.chakde.yyy.session.ABCGateway.execute(ABCGateway.java:67)
at com.xyz.chakde.yyy.session.ABCGateway.execute(ABCGateway.java:37)
at
com.xyz.chakde.yyy.client.servlet.GatewayServlet.execute(GatewayServlet.java
:71)
at
com.xyz.chakde.yyy.client.servlet.GatewayServlet.doPost(GatewayServlet.java:
54)
at
com.xyz.chakde.yyy.client.servlet.GatewayServlet.doGet(GatewayServlet.java:4
2)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:106)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:907)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:851)
at
weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContext
Manager.java:252)
at
weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
at
weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)
; nested exception is:
java.sql.SQLException: Transaction timed out, rolled back and
returned the connection to the pool
java.sql.SQLException: Transaction timed out, rolled back and returned the
connection to the pool
at weblogic.jdbcbase.jts.Driver.connect(Driver.java:263)
at
weblogic.cmp.rdbms.PSRdbms_Base.getConnection(PSRdbms_Base.java:89)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypePSWebLogic_CMP_RDB
MS.refresh(EquipmentTypePSWebLogic_CMP_RDBMS.java:250)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypePSWebLogic_CMP_RDB
MS.load(EquipmentTypePSWebLogic_CMP_RDBMS.java:232)
at
weblogic.ejb.internal.EntityEJBContext.load(EntityEJBContext.java:153)
at
weblogic.ejb.internal.EntityEJBContext.afterBegin(EntityEJBContext.java:214)
at
weblogic.ejb.internal.StatefulEJBObject.getContextForInvoke(StatefulEJBObjec
t.java:162)
at
weblogic.ejb.internal.BaseEJBObject.preInvoke(BaseEJBObject.java:445)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypeBeanEOImpl.getName
(EquipmentTypeBeanEOImpl.java:189)
at
com.xyz.chakde.yyy.entity.persistence.entity.EquipmentTypeEJBAdaptor.getName
(EquipmentTypeEJBAdaptor.java:90)
at
com.xyz.chakde.yyy.request.EventRequest.buildNotify(EventRequest.java:252)
at
com.xyz.chakde.yyy.request.EventRequest.buildNotify(EventRequest.java:211)
at
com.xyz.chakde.yyy.request.UpdateContainerTripRequest.executeEvent(UpdateCon
tainerTripRequest.java:108)
at
com.xyz.chakde.yyy.request.EventRequest.execute(EventRequest.java:92)
at
com.xyz.chakde.yyy.session.RequestSessionBean.execute(RequestSessionBean.jav
a:57)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl.execute(RequestSessionBe
anEOImpl.java:56)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl_ServiceStub.execute(Requ
estSessionBeanEOImpl_ServiceStub.java:220)
at
com.xyz.chakde.yyy.session.ABCSessionBean.execute(ABCSessionBean.java:71)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl.execute(ABCSessionBeanEOImpl
.java:146)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl_ServiceStub.execute(ABCSessi
onBeanEOImpl_ServiceStub.java:263)
at com.xyz.chakde.yyy.session.ABCGateway.execute(ABCGateway.java:67)
at
com.xyz.chakde.yyy.request.BatchRequest.execute(BatchRequest.java:49)
at
com.xyz.chakde.yyy.session.RequestSessionBean.execute(RequestSessionBean.jav
a:57)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl.execute(RequestSessionBe
anEOImpl.java:56)
at
com.xyz.chakde.yyy.session.RequestSessionBeanEOImpl_ServiceStub.execute(Requ
estSessionBeanEOImpl_ServiceStub.java:220)
at
com.xyz.chakde.yyy.session.ABCSessionBean.execute(ABCSessionBean.java:71)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl.execute(ABCSessionBeanEOImpl
.java:146)
at
com.xyz.chakde.yyy.session.ABCSessionBeanEOImpl_ServiceStub.execute(ABCSessi
onBeanEOImpl_ServiceStub.java:263)
at com.xyz.chakde.yyy.session.ABCGateway.execute(ABCGateway.java:67)
at com.xyz.chakde.yyy.session.ABCGateway.execute(ABCGateway.java:37)
at
com.xyz.chakde.yyy.client.servlet.GatewayServlet.execute(GatewayServlet.java
:71)
at
com.xyz.chakde.yyy.client.servlet.GatewayServlet.doPost(GatewayServlet.java:
54)
at
com.xyz.chakde.yyy.client.servlet.GatewayServlet.doGet(GatewayServlet.java:4
2)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:106)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:907)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:851)
at
weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContext
Manager.java:252)
at
weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
at
weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)
Thanks
Gaurav
"Gaurav Khanna" <khan...@yahoo.com> wrote in message
news:3cab4d7e$1...@newsgroups.bea.com...
Thanks
Gaurav
"Gaurav Khanna" <khan...@yahoo.com> wrote in message
news:3cab56b2$1...@newsgroups.bea.com...