ireport+jasperreport 报错

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

zhangzhen6960

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

阅读量1.4k

点赞数

分类专栏： java 文章标签： sql report query

本文链接：https://blog.csdn.net/zhangzhen6960/article/details/7181346

版权

java 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

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的值得不到。