0 Replies Latest reply on Oct 30, 2007 10:13 PM by sgtmcg

    ERROR [org.hibernate.util.JDBCExceptionReporter] Connection

    sgtmcg
    sgtmcg Oct 30, 2007 10:13 PM

      This is killing us. We've a Seam application that seems to be losing database connections after some time. We're getting the following errors:

      ERROR [org.hibernate.util.JDBCExceptionReporter] Connection handle has been closed and is unusable
      2007-10-30 20:34:06,844 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:647)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)
      2007-10-30 20:34:06,845 ERROR [STDERR] at com.ignitecast.IgnitableContentAction.getFeaturedIgnitables(IgnitableContentAction.java:412)
      2007-10-30 20:34:06,845 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor911.invoke(Unknown Source)
      2007-10-30 20:34:06,845 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2007-10-30 20:34:06,845 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.seam.intercept.EJBInvocationContext.proceed(EJBInvocationContext.java:37)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.seam.interceptors.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:47)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.seam.interceptors.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:27)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
      2007-10-30 20:34:06,845 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.seam.intercept.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:53)
      2007-10-30 20:34:06,846 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor317.invoke(Unknown Source)
      2007-10-30 20:34:06,846 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2007-10-30 20:34:06,846 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:71)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:46)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:83)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:102)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.stateful.StatefulContainer.localInvoke(StatefulContainer.java:203)
      2007-10-30 20:34:06,846 ERROR [STDERR] at org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:98)
      2007-10-30 20:34:06,846 ERROR [STDERR] at $Proxy118.getFeaturedIgnitables(Unknown Source)
      2007-10-30 20:34:06,846 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor910.invoke(Unknown Source)
      2007-10-30 20:34:06,847 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2007-10-30 20:34:06,847 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:20)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.intercept.ClientSideInterceptor$1.proceed(ClientSideInterceptor.java:72)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.interceptors.RemoveInterceptor.aroundInvoke(RemoveInterceptor.java:40)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.interceptors.SynchronizationInterceptor.aroundInvoke(SynchronizationInterceptor.java:31)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:69)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:103)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.intercept.ClientSideInterceptor.invoke(ClientSideInterceptor.java:50)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.javassist.tmp.java.lang.Object_$$_javassist_25.getFeaturedIgnitables(Object_$$_javassist_25.java)
      2007-10-30 20:34:06,847 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor909.invoke(Unknown Source)
      2007-10-30 20:34:06,847 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2007-10-30 20:34:06,847 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:20)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:123)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.Component.callComponentMethod(Component.java:1834)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.Component.getInstanceFromFactory(Component.java:1696)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1633)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.Component.getInstance(Component.java:1610)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.jsf.SeamVariableResolver.resolveVariable(SeamVariableResolver.java:53)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.apache.myfaces.config.LastVariableResolverInChain.resolveVariable(LastVariableResolverInChain.java:42)
      2007-10-30 20:34:06,847 ERROR [STDERR] at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:134)
      2007-10-30 20:34:06,847 ERROR [STDERR] at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:73)
      2007-10-30 20:34:06,847 ERROR [STDERR] at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:195)
      2007-10-30 20:34:06,847 ERROR [STDERR] at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
      2007-10-30 20:34:06,847 ERROR [STDERR] at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56)
      2007-10-30 20:34:06,847 ERROR [STDERR] at javax.faces.component.UIData.getValue(UIData.java:1019)
      2007-10-30 20:34:06,847 ERROR [STDERR] at org.jboss.seam.ui.HtmlLink.getSelection(HtmlLink.java:37)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.jboss.seam.ui.HtmlLink.encodeBegin(HtmlLink.java:188)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:280)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.AbstractRowsRenderer.encodeCellChildren(AbstractRowsRenderer.java:283)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.AbstractRowsRenderer.encodeTableHeaderFacet(AbstractRowsRenderer.java:305)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.AbstractGridRenderer.encodeFooter(AbstractGridRenderer.java:59)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.html.DataGridRenderer.doEncodeBegin(DataGridRenderer.java:174)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.html.DataGridRenderer.doEncodeBegin(DataGridRenderer.java:128)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.encodeBegin(RendererBase.java:101)
      2007-10-30 20:34:06,848 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:512)
      2007-10-30 20:34:06,848 ERROR [STDERR] at javax.faces.component.UIData.encodeBegin(UIData.java:547)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.component.UIDataAdaptor.encodeBegin(UIDataAdaptor.java:1041)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:280)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.AjaxContainerRenderer.encodeChildren(AjaxContainerRenderer.java:97)
      2007-10-30 20:34:06,848 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:524)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.component.UIAjaxRegion.encodeChildren(UIAjaxRegion.java:113)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:284)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.TabRendererBase.encodeChildren(TabRendererBase.java:113)
      2007-10-30 20:34:06,848 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:524)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.html.TabPanelRenderer.doEncodeChildren(TabPanelRenderer.java:266)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.richfaces.renderkit.html.TabPanelRenderer.doEncodeChildren(TabPanelRenderer.java:261)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:121)
      2007-10-30 20:34:06,848 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:524)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChild(RendererUtils.java:436)
      2007-10-30 20:34:06,848 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChildren(RendererUtils.java:419)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.html.HtmlGroupRendererBase.encodeEnd(HtmlGroupRendererBase.java:75)
      2007-10-30 20:34:06,849 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:536)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChild(RendererUtils.java:442)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:216)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:98)
      2007-10-30 20:34:06,849 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:536)
      2007-10-30 20:34:06,849 ERROR [STDERR] at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:252)
      2007-10-30 20:34:06,849 ERROR [STDERR] at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:249)
      2007-10-30 20:34:06,849 ERROR [STDERR] at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:573)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:216)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:384)
      2007-10-30 20:34:06,849 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:138)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:63)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:57)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:79)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:49)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.seam.web.SeamFilter.doFilter(SeamFilter.java:84)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      2007-10-30 20:34:06,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      2007-10-30 20:34:06,850 ERROR [STDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      2007-10-30 20:34:06,850 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
      2007-10-30 20:34:06,851 ERROR [STDERR] Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2147)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2023)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
      2007-10-30 20:34:06,851 ERROR [STDERR] ... 152 more
      2007-10-30 20:34:06,851 ERROR [STDERR] Caused by: java.sql.SQLException: Connection handle has been closed and is unusable
      2007-10-30 20:34:06,851 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
      2007-10-30 20:34:06,852 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
      2007-10-30 20:34:06,852 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:184)
      2007-10-30 20:34:06,945 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497)
      2007-10-30 20:34:06,946 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415)
      2007-10-30 20:34:06,946 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
      2007-10-30 20:34:06,946 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1560)
      2007-10-30 20:34:06,946 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:661)
      2007-10-30 20:34:06,946 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      2007-10-30 20:34:06,946 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2144)
      2007-10-30 20:34:06,946 ERROR [STDERR] ... 160 more

      Steps to reproduce:
      1. Access a view that calls an entity.
      2. Navigate away from the view.
      3. Do not return to the view for 7-9 minutes
      4. Return to the view (works)
      5. Refresh and/or navigate to the view a second time after the wait

      BOOM!

      We've looked at everything that we could find relating to timeout in the -ds.xml, standarjboss.xml, and anywhere else we could find it. We are at a loss at this point. Anyone have any thoughts.

      • 854 Views
      • Tags: