Jump to content
Changes to the Jaspersoft community edition download ×

Report encountered this error :


Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...