2002 JI Open Discussion Posted August 17, 2006 Share Posted August 17, 2006 By: Muralidhar bp - pmurli Report encountered this error : 2003-01-11 22:57 Hello, I have developed a small web reports and I am getting this error. Plzz help me. Thanx Murli java.sql.SQLException: Column not found at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java:1790) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:383) at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:207) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:702) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:158) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:457) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:373) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106) at servlets.ListOfCustomerNumberServlet.service(ListOfCustomerNumberServlet.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:263) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2390) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1959) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) NESTED BY : dori.jasper.engine.JRException: Unable to get value for field 'BranchCode' of class 'java.lang.Integer' at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:272) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:702) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:158) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:457) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:373) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106) at servlets.ListOfCustomerNumberServlet.service(ListOfCustomerNumberServlet.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:263) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2390) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1959) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) By: Teodor Danciu - teodord RE: Report encountered this error : 2003-01-13 01:13 Hi, There is a name mismatch between the columns returned in the ResultSet by the query and the report fields that you have declared in your report. For each report field there has to be a column with the same name in the ResultSet. Check the "BranchCode" field. I hope this helps. Teodor Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now