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!

Error: java.sql.SQLRecoverableException: Closed Connection

3122492Feb 24 2016 — edited Feb 24 2016

Jdeveloper version: 12.1.3.0.0

Application server: Weblogic - integrated.

Browser: Google Chrome

During data entry in the application (structure : task - flow with trains with fragments ) , I made a break ( entered data is not recorded in the database ) , and left computer for a while.

After some time I go back to the application, click on any button on the application, and then appear a blue circle ( a process is executed , you should wait ) , and after that in the console appears the following error :

java.sql.SQLRecoverableException: Closed Connection

After that mistake , if  we refresh the application  by clicking enter in the address bar , in that form for data entry appears row with min id(primary key) from table(which is not desirable

Generally, after the inactivity on the application , appears a message of the expiry of the session.

But, when we do not have any activity on the computer for some time this error occurs .

How  to prevent the occurrence of this error?

Detailed error stack:

<oracle.adf.view> <PartialResponseUtils> <handleError> <ADF_FACES-60096:Server Exception during PPR, #1>

oracle.jbo.DMLException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack

trace and error code to investigate the root cause of this exception. Root cause error code is JBO-26064.

at oracle.jbo.server.DBTransactionImpl.closeStatement(DBTransactionImpl.java:5053)

at oracle.jbo.server.ViewObjectImpl.doCloseFreedStatements(ViewObjectImpl.java:14651)

at oracle.jbo.server.ViewObjectImpl.closeFreedStatements(ViewObjectImpl.java:14634)

at oracle.jbo.server.ViewObjectImpl.closeStatementsResetRowSet(ViewObjectImpl.java:14607)

at oracle.jbo.server.ViewObjectImpl.closeStatements(ViewObjectImpl.java:14556)

at oracle.jbo.server.DBTransactionImpl.closeStatements(DBTransactionImpl.java:5203)

at oracle.jbo.server.DBTransactionImpl.closeTransaction(DBTransactionImpl.java:1556)

at oracle.jbo.server.DBTransactionImpl.disconnect(DBTransactionImpl.java:5536)

at oracle.jbo.server.DBTransactionImpl2.disconnect(DBTransactionImpl2.java:364)

at oracle.jbo.server.DBTransactionImpl.reconnect(DBTransactionImpl.java:5736)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

at oracle.adf.model.binding.DCIteratorBinding.getCheckedDataControl(DCIteratorBinding.java:2627)

at oracle.adf.model.binding.DCIteratorBinding.executeQueryIfNeeded(DCIteratorBinding.java:2275)

at oracle.adf.model.binding.DCBindingContainer.internalRefreshControl(DCBindingContainer.java:3286)

at oracle.adf.model.binding.DCBindingContainer.refresh(DCBindingContainer.java:2915)

at oracle.adf.controller.internal.binding.TaskFlowRegionController.doRegionRefresh

(TaskFlowRegionController.java:252)

at oracle.adf.controller.internal.binding.TaskFlowRegionController.refreshRegion(TaskFlowRegionController.java:143)

at oracle.adf.model.binding.DCBindingContainer.internalRefreshControl(DCBindingContainer.java:3244)

at oracle.adf.model.binding.DCBindingContainer.refresh(DCBindingContainer.java:2915)

at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.prepareModel(PageLifecycleImpl.java:113)

at oracle.adf.controller.faces.lifecycle.FacesPageLifecycle.prepareModel(FacesPageLifecycle.java:421)

at oracle.adf.controller.v2.lifecycle.Lifecycle$2.execute(Lifecycle.java:149)

at oracle.adfinternal.controller.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:197)

at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.startPageLifecycle(ADFPhaseListener.java:204)

at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$1.after(ADFPhaseListener.java:370)

at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.afterPhase(ADFPhaseListener.java:89)

at oracle.adfinternal.controller.faces.lifecycle.ADFLifecyclePhaseListener.afterPhase

(ADFLifecyclePhaseListener.java:53)

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

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

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

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

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

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

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

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

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

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

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

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

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

(TrinidadFilterImpl.java:502)

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

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

(TrinidadFilterImpl.java:502)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

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

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

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

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

at java.security.AccessController.doPrivileged(Native Method)

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

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

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

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

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

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

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

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

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

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

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run

(ContainerSupportProviderImpl.java:255)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

Caused by: java.sql.SQLRecoverableException: Closed Connection

at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:7205)

at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1727)

at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1694)

at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:104)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:83)

at oracle.jbo.server.DBTransactionImpl.closeStatement(DBTransactionImpl.java:5027)

... 85 more

## Detail 0 ##

java.sql.SQLRecoverableException: Closed Connection