网站地图
  
  高级搜索
  首页   技术论坛   博客 派计划   产品中心   资源中心   银弹在线   商城  

 
  本文的标签
EOS知识库 (收录443篇)EOSServer (收录121篇)
  SOA2007 - SOA实践
我们何时迈向SOA
——SOA在中国的整体发展现状究竟如何?
我们如何迈向SOA
——中国企业如何迈出实施SOA的第一步?
我们应采用何种技术
——SOA国际标准SCA/SDO的具体内涵?
我们还需要何种技能
——SOA将如何改变系统架构设计以及项目管理过程?

控制台抛出错误:数据库操作错误:Underlying input stream returned zero byte


发布时间:2007-06-14 15:06:26 作者:cservice 出处: 语言:中文 阅读次数:1247

【适用范围】
EOS5.x


【问题描述和定位】
控制台抛出这个错误,sql语句应该是正确的

hljhr.XXFBQTMKSY.biz.bizQueryLanMu.bzg.4
16:49:34,390 INFO  [STDOUT] true
16:49:34,390 INFO  [STDOUT] Begin Send the Suspend Message
16:49:34,546 INFO  [STDOUT] Command Info is com.primeton.studio.debug.DebugCommandInfo@1f3386a
16:49:34,546 INFO  [STDOUT] Finish Send the Suspend Message
16:49:35,156 INFO  [STDOUT] ------ Get the Resume Action :http-0.0.0.0-8080-Processor22(0)
16:49:35,156 INFO  [STDOUT] ------ Finish Resume Action : -----
16:49:35,234 INFO  [STDOUT] Begin Send the Suspend Message
16:49:35,328 INFO  [STDOUT] Command Info is com.primeton.studio.debug.DebugCommandInfo@18f7af7
16:49:35,328 INFO  [STDOUT] Finish Send the Suspend Message
16:49:35,328 INFO  [STDOUT] Exception use case name: bizFaBuXinXiQuery
16:49:35,328 INFO  [STDOUT] com.primeton.tp.core.bizservice.ProcessException
16:49:35,328 INFO  [STDOUT] 	at com.primeton.tp.core.bizservice.state.MethodBizState.invoke(MethodBizState.java)
16:49:35,328 INFO  [STDOUT] 	at com.primeton.tp.core.bizservice.ProcessRunner.implement(ProcessRunner.java)
16:49:35,328 INFO  [STDOUT] 	at com.primeton.tp.core.bizservice.state.SubProcessBizState.invoke(SubProcessBizState.java)
16:49:35,328 INFO  [STDOUT] 	at com.primeton.tp.core.bizservice.ProcessRunner.implement(ProcessRunner.java)
16:49:35,328 INFO  [STDOUT] 	at com.primeton.tp.core.bizservice.ProcessCaller.implement_noEJB(ProcessCaller.java)
16:49:35,328 INFO  [STDOUT] 	at com.primeton.tp.core.bizservice.ProcessCaller.implement(ProcessCaller.java)
16:49:35,328 INFO  [STDOUT] 	at org.apache.jsp.internet.debug.bizlogicDebugger_jsp._jspService(bizlogicDebugger_jsp.java:62)
16:49:35,328 INFO  [STDOUT] 	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
16:49:35,328 INFO  [STDOUT] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
16:49:35,328 INFO  [STDOUT] 	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
16:49:35,328 INFO  [STDOUT] 	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
16:49:35,328 INFO  [STDOUT] 	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
16:49:35,328 INFO  [STDOUT] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
16:49:35,328 INFO  [STDOUT] 	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:72)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
16:49:35,328 INFO  [STDOUT] 	at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:275)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
16:49:35,328 INFO  [STDOUT] 	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
16:49:35,343 INFO  [STDOUT] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:49:35,343 INFO  [STDOUT] 	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
16:49:35,343 INFO  [STDOUT] 	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
16:49:35,343 INFO  [STDOUT] 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
16:49:35,343 INFO  [STDOUT] 	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
16:49:35,343 INFO  [STDOUT] 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
16:49:35,343 INFO  [STDOUT] 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
16:49:35,343 INFO  [STDOUT] 	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
16:49:35,343 INFO  [STDOUT] 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
16:49:35,343 INFO  [STDOUT] 	at java.lang.Thread.run(Thread.java:534)
16:49:35,343 INFO  [STDOUT] Caused by: java.lang.reflect.InvocationTargetException
16:49:35,343 INFO  [STDOUT] 	at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
16:49:35,343 INFO  [STDOUT] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:49:35,343 INFO  [STDOUT] 	at java.lang.reflect.Method.invoke(Method.java:324)
16:49:35,343 INFO  [STDOUT] 	... 41 more
16:49:35,343 INFO  [STDOUT] Caused by: com.primeton.tp.core.dataservice.DataBaseException: 数据库操作错误 : The SQL statement: select top 5 * from FaBuXinXi where LanMuBianHao="21"; the error message: [Microsoft][SQLServer JDBC Driver]Underlying input stream returned zero bytes
16:49:35,343 INFO  [STDOUT] 	at com.primeton.tp.core.dataservice.util.DBError.createDataBaseException(DBError.java)
16:49:35,343 INFO  [STDOUT] 	at com.primeton.tp.core.dataservice.util.DBError.throwSQLException(DBError.java)
16:49:35,343 INFO  [STDOUT] 	at com.primeton.tp.core.dataservice.DBBroker.formatSQLFind(DBBroker.java)
16:49:35,343 INFO  [STDOUT] 	at com.primeton.eos.bizlets.database.Database.BL_runFormatSql(Database.java:689)
16:49:35,343 INFO  [STDOUT] 	... 44 more
16:49:35,343 INFO  [STDOUT] Caused by: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Underlying input stream returned zero bytes
16:49:35,343 INFO  [STDOUT] 	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
16:49:35,343 INFO  [STDOUT] 	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
16:49:35,343 INFO  [STDOUT] 	at com.microsoft.jdbc.base.BaseData.getString(Unknown Source)
16:49:35,343 INFO  [STDOUT] 	at com.microsoft.jdbc.base.BaseData.getObject(Unknown Source)
16:49:35,343 INFO  [STDOUT] 	at com.microsoft.jdbc.base.BaseResultSet.getObject(Unknown Source)
16:49:35,343 INFO  [STDOUT] 	at com.primeton.tp.core.dataservice.result.ResultAdapter.getObject(ResultAdapter.java)
16:49:35,343 INFO  [STDOUT] 	at com.primeton.tp.core.dataservice.result.SQLResultImpl.getObjectFormResult(SQLResultImpl.java)
16:49:35,343 INFO  [STDOUT] 	at com.primeton.tp.core.dataservice.result.SQLResultImpl.buildColElement(SQLResultImpl.java)
16:49:35,343 INFO  [STDOUT] 	at com.


【解决方案和步骤】
1、在SQL Server表中使用了Text类型,如果表中Text类型包含Null时,检索Text类型中包含Null的记录就会出现如上错误
2、检查BL_runFormatSql的sql语句后面是否不小心加了";"

【备注】

 

 评论 查看全部评论
 
asdf 于 2007-08-28
中国石材超市网是全球最大的石材价格石材资讯石材产品的发布地.由福建上百家石材企业共同创建,是中国石材行业价格最透明的商城.
中国石材超市网 主要有石材产品展示石材最新产品石材稀有产品石材特价产品石材行业资讯石材展会信息石材安装技术石材常识石材客户中心等几个大类,石材产品主要包含:大理石花岗岩马赛克砂岩人造石文化石等,对各种石材都有全球最透明的价格,最详细的介绍,最全的石材信息。是石材行业的一个里程碑。中国石材超市网

 

声明:本栏目转载文字、造型、样式、图形及程序如有来自网络,版权归原作者或首发媒体所有,欢迎任何个人访问或者转载,若有作者及出处有误,请来信说明,我们将及时更正。