Report encountered this error :

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