error

[2001 JI Open Discussion]

By: supportsib - supportsib

error

2004-03-16 02:42

i have one master report and one sub report

when i amrunning the master report

t makes the following error

java.sql.SQLException: Column 'ID' not found. at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2260) at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1797) at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:216) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:711) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:172) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:542) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:459) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:159) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:230) at java.lang.Thread.run(Thread.java:536) NESTED BY : java.sql.SQLException: Column 'ID' not found. at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2260) at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1797) at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:216) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:711) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:172) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:542) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:459) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:159) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:230) at java.lang.Thread.run(Thread.java:536) NESTED BY : dori.jasper.engine.JRException: Unable to get value for field 'ID' of class 'java.lang.Integer' at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:315) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:711) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:172) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:542) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:459) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:159) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:230) at java.lang.Thread.run(Thread.java:536) Caused by: java.sql.SQLException: Column 'ID' not found. at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2260) at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1797) at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:216) ... 9 more Print not filled. Try to use an EmptyDataSource...!

 

 

 

By: lotus - lotus007

RE: error

2004-03-16 23:59

I think that you must define "ID" in the report fields, but you don't use it in report query.

 

 

By: zmkwt - ziraj

RE: error------Re lotus00

2004-03-17 00:52

Yes Id exists in report field.

And my goes like select * from ...............

 

 

 

By: lotus - lotus007

RE: error

2004-03-17 17:20

Plz try like this "select id from...."

 

 

By: Giulio Toffoli - gt78

RE: error

2004-03-18 14:29

Please note that fields name are case sensitive.

 

Giulio