I get the error below when I try to execute a query after my HTTP session times out. Do I need a new Hibernate session? Any help would be appreciated.


Hibernate version:3.2


Full stack trace of any exception that occurs:
[5/8/07 15:22:03:281 CDT] 00000038 SystemOut O 15:22:03,266 WARN AbstractBatcher:276 - exception clearing maxRows/queryTimeout
com.ibm.db2.jcc.b.SqlException: Invalid operation: statement closed
at com.ibm.db2.jcc.b.zc.B(zc.java:2402)
at com.ibm.db2.jcc.b.zc.getMaxRows(zc.java:641)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:272)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:209)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1792)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)
at com.fbfs.lf.claims.model.dao.LcltprtyDAO.getClientList(LcltprtyDAO.java:692)
at pagecode.ClientSearch.lifeClaimsClientSearch(ClientSearch.java:196)
at pagecode.ClientSearch.allSearch(ClientSearch.java:146)
at pagecode.ClientSearch.clientSearch(ClientSearch.java:109)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:127)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:73)
at javax.faces.component.UICommand.broadcast(UICommand.java:312)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:302)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:416)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:77)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:201)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:91)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1217)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1173)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)
at com.fbfs.lf.claims.servlet.LifeClaimsFilter.doFilter(LifeClaimsFilter.java:63)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)
at com.fbfs.lf.claims.hibernate.util.HibernateFilter.doFilter(HibernateFilter.java:40)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
[5/8/07 15:22:03:281 CDT] 00000038 SystemOut O 15:22:03,281 WARN JDBCExceptionReporter:77 - SQL Error: -4499, SQLState: null
[5/8/07 15:22:03:281 CDT] 00000038 SystemOut O 15:22:03,281 ERROR JDBCExceptionReporter:78 - A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: insufficient data. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
[5/8/07 15:22:03:281 CDT] 00000038 SystemOut O Hibernate exception[Ljava.lang.StackTraceElement;@c70ad18


Name and version of the database you are using:DB2 8.22


SELECT {Lcltprty.*}, {Lcltptyh.*}, {Lcltadpr.*}, {Lcltaddr.*} FROM DB2TEST.LCLTPRTY AS Lcltprty INNER JOIN DB2TEST.LCLTPTYH AS Lcltptyh ON DB2TEST.LCLTPRTY.I_PARTY_KEY = DB2TEST.LCLTPTYH.I_PARTY_KEY and DB2TEST.LCLTPTYH.D_EXPIRED IS NULL LEFT OUTER JOIN DB2TEST.LCLTADPR AS Lcltadpr ON DB2TEST.LCLTPRTY.I_PARTY_KEY = DB2TEST.LCLTADPR.I_PARTY_KEY and DB2TEST.LCLTADPR.D_EXPIRED IS NULL AND DB2TEST.LCLTADPR.C_PURPOSE = 1 LEFT OUTER JOIN DB2TEST.LCLTADDR AS Lcltaddr ON DB2TEST.LCLTADPR.I_ADDR_PURPOSE_KEY = DB2TEST.LCLTADDR.I_ADDR_PURPOSE_KEY
[5/8/07 15:22:02:891 CDT] 00000038 SystemOut O Hibernate: SELECT Lcltprty.I_PARTY_KEY as I1_10_0_, Lcltprty.C_PARTY_TYPE as C2_10_0_, Lcltprty.C_ORIGINAL_SOURCE as C3_10_0_, Lcltprty.D_CREATED as D4_10_0_, Lcltprty.I_USERID_CREATED as I5_10_0_, Lcltprty.I_MEMBERSHIP_NBR as I6_10_0_, Lcltptyh.I_PTY_HISTORY_KEY as I1_6_1_, Lcltptyh.I_PARTY_KEY as I2_6_1_, Lcltptyh.N_PREFIX as N3_6_1_, Lcltptyh.N_FIRST as N4_6_1_, Lcltptyh.N_MIDDLE as N5_6_1_, Lcltptyh.N_LAST_OR_ORG as N6_6_1_, Lcltptyh.N_SUFFIX as N7_6_1_, Lcltptyh.N_OCCUPATION as N8_6_1_, Lcltptyh.D_BIRTH as D9_6_1_, Lcltptyh.D_DEATH as D10_6_1_, Lcltptyh.C_GENDER as C11_6_1_, Lcltptyh.I_SSN_TIN as I12_6_1_, Lcltptyh.D_EFFECTIVE as D13_6_1_, Lcltptyh.D_EXPIRED as D14_6_1_, Lcltptyh.D_CREATED as D15_6_1_, Lcltptyh.D_CHANGED as D16_6_1_, Lcltptyh.I_USERID_CREATED as I17_6_1_, Lcltptyh.I_USERID_CHANGED as I18_6_1_, Lcltptyh.C_TIN_TYPE as C19_6_1_, Lcltptyh.C_LIFE_STATUS as C20_6_1_, Lcltptyh.C_RES_STATE as C21_6_1_, Lcltadpr.I_ADDR_PURPOSE_KEY as I1_7_2_, Lcltadpr.I_PARTY_KEY as I2_7_2_, Lcltadpr.C_PURPOSE as C3_7_2_, Lcltadpr.D_EFFECTIVE as D4_7_2_, Lcltadpr.D_EXPIRED as D5_7_2_, Lcltadpr.D_CREATED as D6_7_2_, Lcltadpr.D_CHANGED as D7_7_2_, Lcltadpr.I_USERID_CREATED as I8_7_2_, Lcltadpr.I_USERID_CHANGED as I9_7_2_, Lcltaddr.I_PRTY_ADD_HTY_KEY as I1_13_3_, Lcltaddr.I_ADDR_PURPOSE_KEY as I2_13_3_, Lcltaddr.T_LINE1 as T3_13_3_, Lcltaddr.T_LINE2 as T4_13_3_, Lcltaddr.T_LINE3 as T5_13_3_, Lcltaddr.N_CITY as N6_13_3_, Lcltaddr.C_STATE as C7_13_3_, Lcltaddr.I_ZIP5 as I8_13_3_, Lcltaddr.I_ZIP4 as I9_13_3_, Lcltaddr.D_CREATED as D10_13_3_, Lcltaddr.I_USERID_CREATED as I11_13_3_, Lcltaddr.F_FOREIGN as F12_13_3_ FROM DB2TEST.LCLTPRTY AS Lcltprty INNER JOIN DB2TEST.LCLTPTYH AS Lcltptyh ON DB2TEST.LCLTPRTY.I_PARTY_KEY = DB2TEST.LCLTPTYH.I_PARTY_KEY and DB2TEST.LCLTPTYH.D_EXPIRED IS NULL LEFT OUTER JOIN DB2TEST.LCLTADPR AS Lcltadpr ON DB2TEST.LCLTPRTY.I_PARTY_KEY = DB2TEST.LCLTADPR.I_PARTY_KEY and DB2TEST.LCLTADPR.D_EXPIRED IS NULL AND DB2TEST.LCLTADPR.C_PURPOSE = 1 LEFT OUTER JOIN DB2TEST.LCLTADDR AS Lcltaddr ON DB2TEST.LCLTADPR.I_ADDR_PURPOSE_KEY = DB2TEST.LCLTADDR.I_ADDR_PURPOSE_KEY fetch first 11 rows only

How about posting some code yo...