-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: ERROR JDBCExceptionReporter:78 - A communication error has
PostPosted: Tue May 08, 2007 5:27 pm 
Newbie

Joined: Thu Jun 15, 2006 2:15 pm
Posts: 15
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


Top
 Profile  
 
 Post subject:
PostPosted: Wed May 09, 2007 9:50 am 
Senior
Senior

Joined: Sat Apr 21, 2007 11:01 pm
Posts: 144
How about posting some code yo...

_________________
Everytime you get an answer to your question without giving credit; god kills a kitten. :(


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.