I believe I can fly

          蟲蟲的Blog

            BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理 ::
            8 隨筆 :: 2 文章 :: 2 評論 :: 0 Trackbacks

          最近在用SSH做一個軟件,在測試時,發(fā)現(xiàn)如果多刷新幾次頁面,提示Socket closed錯誤,貌似是連接丟失造成的,但是奇怪的是,過一段時間再刷新時,又正常了,再這樣刷幾次,又出同樣的問題。查了好多資料,實在搞不定了。不知哪位同仁遇到過同樣的問題,控制臺輸入如下:

          2009-05-21 23:10:01,734 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Er
          ror: 
          17002, SQLState: null
          2009-05-21 23:10:01,734 ERROR [org.hibernate.util.JDBCExceptionReporter] - Io 異
          常: Socket closed
          2009-05-21 23:10:01,734 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Er
          ror: 
          17002, SQLState: null
          2009-05-21 23:10:01,734 ERROR [org.hibernate.util.JDBCExceptionReporter] - Io 異
          常: Socket closed
          org.hibernate.exception.GenericJDBCException: could not execute query
                  at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificExceptio
          n(ErrorCodeConverter.java:
          92)
                  at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter
          .java:
          80)
                  at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
          er.java:
          43)
                  at org.hibernate.loader.Loader.doList(Loader.java:
          1596)
                  at org.hibernate.loader.Loader.list(Loader.java:
          1577)
                  at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:
          395)
                  at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
          va:
          271)
                  at org.hibernate.impl.SessionImpl.list(SessionImpl.java:
          844)
                  at org.hibernate.impl.QueryImpl.list(QueryImpl.java:
          74)
                  at com.tkp.crm.dao.impl.ICustomerDAOImpl.queryAll(ICustomerDAOImpl.java:
          22)
                  at com.tkp.crm.struts.action.CustomerAction.listAll(CustomerAction.java:
          59)
                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
          java:
          39)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
          sorImpl.java:
          25)
                  at java.lang.reflect.Method.invoke(Method.java:
          585)
                  at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchActio
          n.java:
          270)
                  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:
          187)
                  at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
          tProcessor.java:
          431)
                  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
          va:
          236)
                  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:
          119
          6)
                  at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:
          414)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:
          689)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:
          802)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
          icationFilterChain.java:
          237)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
          ilterChain.java:
          157)
                  at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
          atcher.java:
          704)
                  at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
          tionDispatcher.java:
          474)
                  at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
          ispatcher.java:
          409)
                  at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
          patcher.java:
          312)
                  at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.j
          ava:
          670)
                  at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav
          a:
          637)
                  at org.apache.jsp.index_jsp._jspService(index_jsp.java:
          72)
                  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:
          94)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:
          802)
                  at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
          .java:
          324)
                  at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:
          2
          92)
                  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:
          236)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:
          802)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
          icationFilterChain.java:
          237)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
          ilterChain.java:
          157)
                  at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.
          do
          FilterInternal(OpenSessionInViewFilter.java:
          198)
                  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
          equestFilter.java:
          75)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
          icationFilterChain.java:
          186)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
          ilterChain.java:
          157)
                  at com.tkp.crm.filter.EncodingFilter.doFilter(EncodingFilter.java:
          22)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
          icationFilterChain.java:
          186)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
          ilterChain.java:
          157)
                  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
          alve.java:
          214)
                  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
          eContext.java:
          104)
                  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
          a:
          520)
                  at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
          ContextValve.java:
          198)
                  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
          alve.java:
          152)
                  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
          eContext.java:
          104)
                  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
          a:
          520)
                  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
          ava:
          137)
                  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
          eContext.java:
          104)
                  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
          ava:
          118)
                  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
          eContext.java:
          102)
                  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
          a:
          520)
                  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
          ve.java:
          109)
                  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
          eContext.java:
          104)
                  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
          a:
          520)
                  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:
          929)

                  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:
          16
          0)
                  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
          :
          799)
                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
          ssConnection(Http11Protocol.java:
          705)
                  at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
          :
          577)
                  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
          ool.java:
          683)
                  at java.lang.Thread.run(Thread.java:
          595)
          Caused by: java.sql.SQLException: Io 異常: Socket closed
                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
          134)
                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
          179)
                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
          333)
                  at oracle.jdbc.driver.OracleStatement.
          <init>(OracleStatement.java:389)
                  at oracle.jdbc.driver.OracleStatement.
          <init>(OracleStatement.java:413)
                  at oracle.jdbc.driver.OraclePreparedStatement.
          <init>(OraclePreparedState
          ment.java:
          119)
                  at oracle.jdbc.driver.OraclePreparedStatement.
          <init>(OraclePreparedState
          ment.java:
          92)
                  at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleCon
          nection.java:
          950)
                  at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection
          .java:
          802)
                  at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(Delegat
          ingConnection.java:
          248)
                  at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.
          prepareStatement(PoolingDataSource.java:
          302)
                  at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
          er.java:
          396)
                  at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
          er.java:
          334)
                  at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
          her.java:
          88)
                  at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:
          1162)
                  at org.hibernate.loader.Loader.doQuery(Loader.java:
          390)
                  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
          ader.java:
          218)
                  at org.hibernate.loader.Loader.doList(Loader.java:
          1593)
                   
          65 more
          2009-05-21 23:10:05,015 WARN [org.hibernate.jdbc.ConnectionManager] - unclosed c
          onnection, forgot to call close() on your session
          ?


          QQ交流群:90623790
          posted on 2009-05-21 23:17 蟲蟲 閱讀(1973) 評論(0)  編輯  收藏

          只有注冊用戶登錄后才能發(fā)表評論。


          網(wǎng)站導航:
           
          主站蜘蛛池模板: 绥宁县| 天峻县| 汝南县| 凌海市| 常宁市| 民乐县| 苍梧县| 通化市| 汝南县| 华阴市| 朝阳县| 磐石市| 土默特右旗| 明水县| 吉安县| 韶关市| 平度市| 信丰县| 涞水县| 吕梁市| 榆中县| 高陵县| 株洲市| 溧阳市| 新绛县| 宜川县| 临清市| 庆阳市| 蕲春县| 兴隆县| 彭泽县| 郓城县| 阳泉市| 无棣县| 阳高县| 余姚市| 青岛市| 芜湖县| 三明市| 岳西县| 绥中县|