【适用范围】
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语句后面是否不小心加了";"
【备注】
|