ireport+jasperreport 报错

最新推荐文章于 2021-08-27 12:56:38 发布

原创最新推荐文章于 2021-08-27 12:56:38 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #report #query

java 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了如何解决在使用JasperReports执行报告查询时遇到的SQL错误，具体为无法解析COMIDS的问题。通过检查并修改SQL语句，成功解决了这一问题。

net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query :

SELECT MAX(E.COMNO) AS COMNO,
           MAX(E.COMNAME) AS COMNAME,
           SUM(A.QTY) AS QTY,
           SUM(A.CSAMT) AS CSAMT,
           D.DOCNO AS DOC70NO
FROM BASPLUSTOCK A , DOC70BF D,BASCOMMAIN E
WHERE    A.LOCTYP = 3
   AND A.DOC70NO = D.DOCNO AND D.COMID = E.COMID
   AND D.COMID   IN {COMIDS} AND E.COMNO = ?
GROUP BY D.DOCNO

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:240)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:131)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:686)

Caused by: java.sql.SQLException: 出现不支持的 SQL92 标记: 312: COMIDS
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)

解决方法：

sql语句有问题，仔细看看自己的sql语句，这个错误时comids的值得不到。