无法打开驱动程序的连接：org.eclipse.birt.report.data.oda.jdbc
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4868609/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
提问by Mara
I got the following problem
我遇到了以下问题
In Eclipse, in the Report Design Perspective , when I try to preview I get the following error:
在 Eclipse 中，在 Report Design Perspective 中，当我尝试预览时出现以下错误：
Chart NewChart:
+ An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.mysql.jdbc.Driver.
I also checked in Eclipse in the folder org.eclipse.birt.report.data.oda.jdbc/drivers and it was empty. Should it be? I checked the externalLibs directory, and there I have mysql-connector.jar and I do not know what to check for next.
我还在文件夹 org.eclipse.birt.report.data.oda.jdbc/drivers 中检查了 Eclipse，它是空的。应该是吗？我检查了 externalLibs 目录，那里有 mysql-connector.jar，但我不知道接下来要检查什么。
采纳答案by Tom Seidel
Your JDBC driver must be copied to that directory, see also http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php#install_jdbc
您的 JDBC 驱动程序必须复制到该目录，另请参见http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php#install_jdbc
回答by Mainak
Do one thing MARA, go to the Data Sourceoption. Select JDBC Connectionover there do Next. You will find an Manage Driversbutton in the left-bottom of the window. Select it, a new console window named Manage JDBC Driverswill evolve. There you will find two tabs Jar Files and Driver. Now select Jar Files and add a newly created .jarfile (know how to create a .jar file it's quite easy, google it). Click Ok. You are done.
做一件事 MARA，转到数据源选项。选择JDBC Connection那边做Next。您会Manage Drivers在窗口的左下角找到一个按钮。选择它，一个名为Manage JDBC Drivers的新控制台窗口将会演化。在那里你会找到两个选项卡 Jar 文件和驱动程序。现在选择 Jar Files 并添加一个新创建的.jar文件（知道如何创建 .jar 文件很容易，谷歌它）。单击Ok。你完成了。
Now whenever you will go the data source and select Driver Class= com.microsoft.sqlserver.jdbc.SQLServerDriver.(Or you may see its turned to com.microsoft.sqlserver.jdbc.SQLServerDriver(com.microsoft.sqlserver.jdbc.SQLServerDriver (v4.0) v4.0)) just write the connection string on the Base url. (Don't forget to open a port from the server side you are using).
现在，无论何时您将转到数据源并选择Driver Class= com.microsoft.sqlserver.jdbc.SQLServerDriver。（或者您可能会看到它转向com.microsoft.sqlserver.jdbc.SQLServerDriver(com.microsoft.sqlserver.jdbc.SQLServerDriver (v4.0) v4.0)），只需在Base url上写入连接字符串。（不要忘记从您正在使用的服务器端打开一个端口）。
Hope it works.
希望它有效。
回答by Ajay
This worked for me
这对我有用
Download mysql-connector-java-5.1.44-bin.jarfile from google
从谷歌下载mysql-connector-java-5.1.44-bin.jar文件
Paste the jar file to location: Eclipse?/?Contents?/?Eclipse?/?plugins?/org.eclipse.birt.report.data.oda.jdbc_.../drivers?* folder
将 jar 文件粘贴到位置：Eclipse?/?Contents?/?Eclipse?/?plugins?/org.eclipse.birt.report.data.oda.jdbc_.../drivers?*文件夹
or
或者
paste "mysql-connector-java-5.0.8-bin.jar" jar file to
将“mysql-connector-java-5.0.8-bin.jar”jar 文件粘贴到
location: WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_INSTALLED_VERSION\driversfolder
位置：WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_INSTALLED_VERSION\drivers文件夹
Go to manage drivers, under jar filessection use addoption and select the mysql-connector-java-5.1.44-bin.jarfile from any location from your local machine and then Test Connection
转到管理驱动程序，在jar 文件部分下使用添加选项并从本地计算机的任何位置选择mysql-connector-java-5.1.44-bin.jar文件，然后测试连接
Connection Successful
连接成功
