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
|