<Oct 31, 2013 10:41:36 AM CST> <Error> <HTTP> <BEA-101017> <[ServletContext@25411576[app:circ-shusedcar module:circ-shusedcar.war path:/circ-shusedcar spec-version:2.5]] Root cause of ServletException.
com.ebaotech.riaw.one.common.exception.ServiceException: org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [select CARMARK_CATEGORY_CODE as code, CARMARK_CATEGORY_NAME as text  from T_CARMARK_CATEGORY_DESC where 1 = 1]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket
        at com.ebaotech.riaw.one.service.frame.impl.FrameServiceImpl.findCodes(FrameServiceImpl.java:73)
        at com.ebaotech.riaw.one.controller.frame.FrameController.findCodes(FrameController.java:82)
        at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        Truncated. see log file for complete stacktraceCaused By: org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [select CARMARK_CATEGORY_CODE as code, CARMARK_CATEGORY_NAME as text  from T_CARMARK_CATEGORY_DESC where 1 = 1]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket
        at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:99)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
        Truncated. see log file for complete stacktrace                                                                                                                  29920,1       88%
10:41:35,940  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/js/jquery-ui-1.10.3/themes/blitzer/jquery.ui.spinner.css
10:41:35,943  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/js/jquery-ui-1.10.3/themes/blitzer/jquery.ui.tabs.css
10:41:35,983  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/js/jquery-ui-1.10.3/themes/blitzer/jquery.ui.tooltip.css
10:41:35,983  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/js/jquery-ui-1.10.3/themes/blitzer/jquery.ui.resizable.css
10:41:36,367  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/images/TitleDY.png
10:41:36,367  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/images/banner_top.png
10:41:36,372  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/images/UserIcon.png
10:41:36,450  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/images/CloseIcon.png
10:41:36,493  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/images/Banner_Bottom.jpg
10:41:36,543  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/images/Background.png
10:41:36,692  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/resources/js/jquery-ui-1.10.3/themes/blitzer/images/ui-bg_flat_75_ffffff_40x100.png
10:41:36,741  INFO AuthorizationFilter:42 - requestURI: /circ-shusedcar/frame/code
10:41:36,742  INFO FrameController:72 - refName:CARMARK_CATEGORY, pid: null, filter: null
10:41:36,778  INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
10:41:36,812  INFO SQLErrorCodesFactory:126 - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
<Oct 31, 2013 10:41:36 AM CST> <Error> <HTTP> <BEA-101017> <[ServletContext@25411576[app:circ-shusedcar module:circ-shusedcar.war path:/circ-shusedcar spec-version:2.5]] Root cause of ServletException.
com.ebaotech.riaw.one.common.exception.ServiceException: org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [select CARMARK_CATEGORY_CODE as code, CARMARK_CATEGORY_NAME as text  from T_CARMARK_CATEGORY_DESC where 1 = 1]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket
        at com.ebaotech.riaw.one.service.frame.impl.FrameServiceImpl.findCodes(FrameServiceImpl.java:73)
        at com.ebaotech.riaw.one.controller.frame.FrameController.findCodes(FrameController.java:82)
        at sun.reflect.GeneratedMethodAccessor309.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        Truncated. see log file for complete stacktrace

解决方案 »

  1.   

     sql语句的问题
    应该是没取到数据把
      

  2.   

     T_CARMARK_CATEGORY_DESC这个表是通过本地的创建dblink,然后创建该表的同义词进行远程读取的。但我一共创建了7张表的同义词,而且在plsql中是能够select的,只是在日志中存在这个表的报错信息。通过ie页面我能够访问到该表的数据,但有时访问不到。