解决java.sql.SQLException: ORA-01789: query block has incorrect number of result columns

2022-07-09 08:59:04

java.sql.SQLException: ORA-01789: query block has incorrect number of result columns

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)

at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)

at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:894)

at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:984)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1124)

at com.topcheer.ybt.daos.DAO.findAll(DAO.java:187)

at com.topcheer.ybt.events.QueryBillsEvents.getDownloadSearchBill(QueryBillsEvents.java:2260)

at com.topcheer.ybt.events.QueryBillsEvents.download(QueryBillsEvents.java:1173)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.ofbiz.core.event.JavaEventHandler.invoke(JavaEventHandler.java:114)

at org.ofbiz.core.event.JavaEventHandler.invoke(JavaEventHandler.java:96)

at org.ofbiz.core.control.RequestHandler.runEvent(RequestHandler.java:580)

at org.ofbiz.core.control.RequestHandler.doRequest(RequestHandler.java:368)

at org.ofbiz.core.control.ControlServlet.doGet(ControlServlet.java:200)

at org.ofbiz.core.control.ControlServlet.doPost(ControlServlet.java:140)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.topcheer.common.filter.SessionFilter.doFilter(SessionFilter.java:89)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.topcheer.common.EncodingFilter.doFilter(EncodingFilter.java:69)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.topcheer.ybt.web.LogFilter.doFilter(LogFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

at java.lang.Thread.run(Thread.java:619)

2710317[ RequestHandler.java:727:INFO ] servletName=control, view=downloadDetailBill

2014-6-24 18:28:39 org.apache.catalina.core.ApplicationDispatcher invoke

严重: Servlet.service() for servlet jsp threw exception

java.lang.IllegalStateException: getOutputStream() has already been called for this response

at org.apache.catalina.connector.Response.getWriter(Response.java:610)

at org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:198)

at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:112)

at org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:125)

at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:118)

at org.apache.jasper.runtime.JspWriterImpl.flush(JspWriterImpl.java:173)

at org.ofbiz.core.region.Section.render(Section.java:84)

at org.ofbiz.core.region.RenderTag.doEndTag(RenderTag.java:91)

at org.apache.jsp.templates.main_005ftemplate_jsp._jspx_meth_region_005frender_005f0(main_005ftemplate_jsp.java:182)

at org.apache.jsp.templates.main_005ftemplate_jsp._jspService(main_005ftemplate_jsp.java:81)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)

at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)

at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)

at org.ofbiz.core.region.Region.render(Region.java:177)

at org.ofbiz.core.view.RegionViewHandler.render(RegionViewHandler.java:115)

at org.ofbiz.core.control.RequestHandler.renderView(RequestHandler.java:805)

at org.ofbiz.core.control.RequestHandler.handleNextView(RequestHandler.java:501)

at org.ofbiz.core.control.RequestHandler.doRequest(RequestHandler.java:415)