Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inconsistent issue: java.sql.SQLException, msg=Connection has already been closed.

2661784Apr 28 2014 — edited Apr 28 2014

When running locally in Integrated Weblogic Server my application runs fine without any issues.However when running in one of our QA env I am facing issues.The log is pasted below.

I have cleared the data in PS_TXN and tried running but still facing the same issue.Any pointers in this regard will be highly helpful.

Log:

oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=Connection has already

been closed.

at oracle.jbo.server.DBTransactionImpl.getDatabaseProductName(DBTransactionImpl.java:1275)

at oracle.jbo.server.DBTransactionImpl.getInternalConnection(DBTransactionImpl.java:1382)

at oracle.jbo.server.DBTransactionImpl.getPersistManagerConnection(DBTransactionImpl.java:1309)

at oracle.jbo.pcoll.PCollManager.ensureConnection(PCollManager.java:486)

at oracle.jbo.pcoll.OraclePersistManager.getConnection(OraclePersistManager.java:153)

at oracle.jbo.pcoll.OraclePersistManager.insert(OraclePersistManager.java:1881)

at oracle.jbo.pcoll.PCollNode.passivateElem(PCollNode.java:564)

at oracle.jbo.pcoll.PCollNode.passivate(PCollNode.java:688)

at oracle.jbo.pcoll.PCollNode.passivateBranch(PCollNode.java:647)

at oracle.jbo.pcoll.PCollection.passivate(PCollection.java:465)

at oracle.jbo.server.DBSerializer.passivateRootAM(DBSerializer.java:294)

at oracle.jbo.server.DBSerializer.passivateRootAM(DBSerializer.java:267)

at oracle.jbo.server.ApplicationModuleImpl.passivateStateInternal(ApplicationModuleImpl.java:6007)

at oracle.jbo.server.ApplicationModuleImpl.passivateState(ApplicationModuleImpl.java:5867)

at oracle.jbo.common.ampool.DefaultConnectionStrategy.reconnect(DefaultConnectionStrategy.java:290)

at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolReconnect(ApplicationPoolMessageHandler.java:618)

at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:406)

at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9084)

at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4607)

at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2537)

at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2357)

at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3246)

at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:572)

at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:234)

at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:505)

at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:500)

at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:523)

at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:871)

at oracle.adf.model.binding.DCBindingContainer.findDataControl(DCBindingContainer.java:1640)

at oracle.adf.model.binding.DCIteratorBinding.initDataControl(DCIteratorBinding.java:2472)

at oracle.adf.model.binding.DCIteratorBinding.getDataControl(DCIteratorBinding.java:2416)

at oracle.adf.model.binding.DCIteratorBinding.refresh(DCIteratorBinding.java:4363)

at oracle.adf.model.binding.DCExecutableBinding.refreshIfNeeded(DCExecutableBinding.java:342)

at oracle.adf.model.binding.DCIteratorBinding.internalGetCurrentRowInBinding(DCIteratorBinding.java:2216)

at oracle.jbo.uicli.binding.JUIteratorBinding.internalGetCurrentRowInBinding(JUIteratorBinding.java:500)

at oracle.adf.model.binding.DCIteratorBinding.getCurrentRow(DCIteratorBinding.java:2203)

at oracle.adf.model.binding.DCControlBinding.getCurrentRow(DCControlBinding.java:387)

at oracle.jbo.uicli.binding.JUControlBinding.getCurrentRow(JUControlBinding.java:98)

at oracle.jbo.uicli.binding.JUCtrlValueBinding.internalGetRow(JUCtrlValueBinding.java:1314)

at oracle.jbo.uicli.binding.JUCtrlValueBinding.getInputValue(JUCtrlValueBinding.java:2740)

at oracle.jbo.uicli.binding.JUCtrlValueBinding.getInputValue(JUCtrlValueBinding.java:2729)

at oracle.adfinternal.view.faces.model.binding.FacesCtrlAttrsBinding.getInputValue

(FacesCtrlAttrsBinding.java:185)

at oracle.jbo.uicli.binding.JUCtrlValueBinding.internalGet(JUCtrlValueBinding.java:2314)

at oracle.adfinternal.view.faces.model.binding.FacesCtrlAttrsBinding.internalGet

(FacesCtrlAttrsBinding.java:277)

at oracle.adf.model.binding.DCControlBinding.get(DCControlBinding.java:749)

at javax.el.MapELResolver.getValue(MapELResolver.java:196)

at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:175)

at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:200)

at com.sun.el.parser.AstValue.getValue(AstValue.java:138)

at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206)

at org.apache.myfaces.trinidad.bean.FacesBeanImpl.getProperty(FacesBeanImpl.java:68)

at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer._getUncachedReadOnly

(EditableValueRenderer.java:473)

at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer.getReadOnly

(EditableValueRenderer.java:400)

at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer.wasSubmitted

(EditableValueRenderer.java:343)

at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer.decodeInternal

(EditableValueRenderer.java:116)

at oracle.adfinternal.view.faces.renderkit.rich.LabeledInputRenderer.decodeInternal

(LabeledInputRenderer.java:57)

at oracle.adf.view.rich.render.RichRenderer.decode(RichRenderer.java:294)

at org.apache.myfaces.trinidad.component.UIXComponentBase.__rendererDecode(UIXComponentBase.java:1118)

at org.apache.myfaces.trinidad.component.UIXComponentBase.decode(UIXComponentBase.java:718)

at org.apache.myfaces.trinidad.component.UIXComponentBase.processDecodes(UIXComponentBase.java:802)

at org.apache.myfaces.trinidad.component.UIXEditableValue.processDecodes(UIXEditableValue.java:238)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ApplyRequestValuesCallback.invokeContextCallback

(LifecycleImpl.java:1395)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1411)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1424)

at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:720)

at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:678)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnNamingContainerComponent

(UIXComponentBase.java:1380)

at oracle.adf.view.rich.component.fragment.UIXRegion.invokeOnComponent(UIXRegion.java:555)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1424)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.invokeOnComponent

(ContextSwitchingComponent.java:194)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1424)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at oracle.adf.view.rich.component.fragment.UIXInclude.invokeOnComponent(UIXInclude.java:147)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1424)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents

(UIXComponentBase.java:1330)

at org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1424)

at oracle.adf.view.rich.component.rich.RichDocument.invokeOnComponent(RichDocument.java:168)

at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:720)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:407)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:194)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.portlet.client.adapter.adf.ADFPortletFilter.doFilter(ADFPortletFilter.java:34)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.webcenter.framework.events.dispatcher.EventDispatcherFilter.doFilter

(EventDispatcherFilter.java:45)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:205)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:106)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter

(TrinidadFilterImpl.java:447)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter

(TrinidadFilterImpl.java:447)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl

(TrinidadFilterImpl.java:271)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.wcps.client.PersonalizationFilter.doFilter(PersonalizationFilter.java:75)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.webcenter.content.integration.servlets.ContentServletFilter.doFilter

(ContentServletFilter.java:168)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.webcenter.lifecycle.filter.LifecycleLockFilter.doFilter(LifecycleLockFilter.java:151)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run

(WebAppServletContext.java:3696)

... 6 more

Caused by: java.sql.SQLException: Connection has already been closed.

at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:62)

at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100)

at weblogic.jdbc.wrapper.Connection.getMetaData(Connection.java:476)

at oracle.jbo.server.DBTransactionImpl.getDatabaseProductName(DBTransactionImpl.java:1263)

... 130 more

## Detail 0 ##