Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Transaction timed out

0 views
Skip to first unread message

Gaurav Khanna

unread,
Apr 3, 2002, 1:44:16 PM4/3/02
to
Hi all,

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)


Gaurav Khanna

unread,
Apr 3, 2002, 1:48:51 PM4/3/02
to
or it might be the fact that the driver is unable to connect to the database
instance. If that is the case then the no of connections that the database
instance (which is Oracle 8i) can accept needs to be increased.
I need to confirm whether that is the case and if anybody has witnessed and
found a solution for this.

Thanks
Gaurav

"Gaurav Khanna" <khan...@yahoo.com> wrote in message
news:3cab4d7e$1...@newsgroups.bea.com...

Gaurav Khanna

unread,
Apr 3, 2002, 2:51:48 PM4/3/02
to
But as far as I can see the no of connections that the oracle instance can
accept is already pretty high and the no of connections that are currently
open do not even get close to that level.

Thanks
Gaurav

"Gaurav Khanna" <khan...@yahoo.com> wrote in message

news:3cab56b2$1...@newsgroups.bea.com...

0 new messages