eclipse开发birt报表时预览数据错误修改方案

最新推荐文章于 2021-06-23 15:32:21 发布

gnolzhao

最新推荐文章于 2021-06-23 15:32:21 发布

阅读量1.2w

点赞数

分类专栏： java DB

本文链接：https://blog.csdn.net/gnolzhao/article/details/50148167

版权

在使用 Eclipse 开发 BIRT 报表时遇到预览数据错误，问题根源是 MySQL 数据库版本（5.6.16）与驱动版本（5.1.16）不匹配。解决方法是更新 MySQL 驱动到 mysql-connector-java-5.1.37.jar，下载驱动后问题得到解决。

摘要由CSDN通过智能技术生成

org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:316)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:278)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:89)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:68)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:372)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=500' at line 1
;
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=500' at line 1