我想在iReport报表中 实现 一个超链接
但是数据库中没有 该 字段
编译可以通过,但是不能预览 (是不是根本就不能实现???)
希望知道的各位兄弟姐妹告知小弟!!!小弟感激不尽!!
错误信息 如下:
Filling report...
Error filling print...
java.sql.SQLException: 列名无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:270) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) NESTED BY : java.sql.SQLException: 列名无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:270) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) NESTED BY : net.sf.jasperreports.engine.JRException: Unable to get value for field '网易' of class 'java.lang.String' at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:279) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: 列名无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:270) ... 9 more
但是数据库中没有 该 字段
编译可以通过,但是不能预览 (是不是根本就不能实现???)
希望知道的各位兄弟姐妹告知小弟!!!小弟感激不尽!!
错误信息 如下:
Filling report...
Error filling print...
java.sql.SQLException: 列名无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:270) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) NESTED BY : java.sql.SQLException: 列名无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:270) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) NESTED BY : net.sf.jasperreports.engine.JRException: Unable to get value for field '网易' of class 'java.lang.String' at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:279) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: 列名无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285) at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5278) at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:698) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1505) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:270) ... 9 more
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货