Invalid Column Name

[2002 JI Open Discussion]

By: Michael Mai - mmai
Invalid Column Name
2003-08-22 10:05
Hi,
When i ran the report I got the following msg, I can figure out what's wrong with xml. I can use the same sql and get the data back from Oracle 8i W/O any problem.

################################
run:

(java) java.sql.SQLException: Invalid column name	(java) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)	(java) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)	(java) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)	(java) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5971)	(java) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1527)	(java) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)	(java) at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:263)	(java) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:759)	(java) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:180)	(java) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:524)	(java) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:433)	(java) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119)	(java) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)	(java) at dori.jasper.engine.JasperRunManager.runReportToPdfFile(JasperRunManager.java:106)	(java) at GenerateIncentiveAward.main(GenerateIncentiveAward.java:129)	(java)	(java) NESTED BY :	(java) dori.jasper.engine.JRException: Unable to get value for field 'Agent_Name' of class 'java.lang.String'	(java) at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:272)	(java) at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:759)	(java) at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:180)	(java) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:524)	(java) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:433)	(java) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119)	(java) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)	(java) at dori.jasper.engine.JasperRunManager.runReportToPdfFile(JasperRunManager.java:106)	(java) at GenerateIncentiveAward.main(GenerateIncentiveAward.java:129)	(java) Java Result: 1	##########################

Here are my report xml:
*********************************

    &reportFonts;                                                                                                                                         ($V{ReportToNumber} != null)?(new Integer($V{ReportToNumber}.intValue() + 1)):(new Integer(1))                        $P{peid}                                                                                                                                                                                                                                                                                                        [/code]

**************************************

Please advise!

By: Michael Mai - mmai
RE: Invalid Column Name
2003-08-22 10:12
Never mind. I got it fixed.

The columns returned in the ResultSet by the query and the report fields that I declared in
my report must be matched.