[JBoss Seam] - ERROR [org.hibernate.util.JDBCExceptionReporter] Connection
by sgtmcg
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.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100482#4100482
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100482
18Â years, 5Â months
[EJB 3.0] - JPQL syntax question - entity bean loading
by X490812
I have an entity bean X similar to the following:
| @Entity
| @SequenceGenerator(name = "FRAUD_CASENUMBER_SEQ", sequenceName = "FRAUD_CASENUMBER_SEQ")
| public class Tblcase implements Serializable {
| // LOBS
| @Lob
| @Basic(fetch=FetchType.LAZY)
| public String fraudfindingnotes;
| .
| .
| //REGULAR FIELDS
| public BigDecimal mgmtrvdother;
| .
| .
| //LOOKUP TABLES
| @OneToOne
| @JoinColumn(name = "CHRFRAUDCODE", referencedColumnName = "CHRFRAUDCODE", insertable = false, updatable = false)
| public TblmatrixFraudcode tblmatrixFraudcode;
|
| @OneToOne
| @JoinColumn(name = "NAME", referencedColumnName = "NAME", insertable = false, updatable = false)
| public Tbluser tbluser;
|
| @OneToOne
| @JoinColumn(name = "CASETYPECD", referencedColumnName = "CASETYPECD", insertable = false, updatable = false)
| public Tblcasetyperef tblcasetyperef;
| .
| .
| .
| .
| }
|
|
|
|
|
What I want to do is return a list of the above entity bean BUT I want it to only hold the PK, AND a few one-to-one fields instead of the all the fields in the entity bean - I dont need complete entities up front; The issue is that a select * statement for the entity takes way to long when I have many rows. When I remove the lobs from the select statement, the execution time is reduced measurably - and no, there is no table scanning going on.
Does someone have an example of syntax for a jpql statment that will allow me to select specific fields - some fields being one-to-one relationships, using an outer join. The statement will run and load the above entity bean with those selected fields so that I have a list of entity beans. Later on, when a row is selected by the user, I can load the full entity bean for the PK he selected
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100471#4100471
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100471
18Â years, 5Â months