我已经使用Tomcat 8.0.5在Microsoft 2012上安装了BIRT 4.3.2Web查看器。当试图通过BIRT查看器连接到数据库时,我会得到以下错误。org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing.Please see the following message for details:
Cannot open the connection for the driver: org.eclips
我使用JDBC connection com.mysql.jdbc.Driver ( v5.0)在SpagoBI中建立了一个数据源连接,连接是succesfull.Then我开始构建一个新的数据集。: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(Mysql
mysql-connector-java-5.0.8-bin.jar是我放在lib文件夹中的mysql连接器,如果我更改密码,它会抛出密码异常,这意味着jar被正确地放置在项目中,但是当mysql的所有凭据都正确时/Statement$CancelTask at com.mysql.jdbc.Connection.createStatementcom.
(ExpressionCompiler.java:68) at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.compile(ExpressionCompilerUtil.java:56) at org.eclipse.birt.data.engine.impl。(QueryResults.java:174) at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterat
我想在BIRT中添加mysql数据库的数据源。但我有一个只能从特定服务器访问的数据库。所以我通过SSH连接到该服务器,然后连接到mysql。(在mysql工作台中,我使用"TCP/IP over SSH“方法访问此数据库。)我对BIRT完全陌生,我想知道是否有一种方法可以通过SSH访问mysql数据库,或者我应该考虑将我的报表部署到可以访问数据库的服
我在BIRT Eclipce Designer中创建报表。数据库为MySQL服务器。原因:
Plug-in org.eclipse.birt.report.viewer was unable to load class org.eclipse.birt.report.servlet.ViewerServlet
Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbcorg.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.mysql.jdbc.Driver我还检查了Eclipse中org.eclipse.birt.rep