“无法找到 JAR/zip” JDBC 连接错误 [BIRT Eclipse、Windows 7、Oracle 11g]
仅供参考，我对整个堆栈都是新手，所以我可能会犯一个基本错误。
我正在尝试探索最近升级的 Maximo 系统的 BIRT 报告。
为此，我安装了以下软件：
- Java 6 & Java 7 JDK
- BIRT 版本的 Eclipse（内置 Eclipse + BIRT 插件）。
- 一些 Oracle 11gR2 客户端选项（自定义安装）
- SQL*Plus
- JDBC/ODBC 驱动程序
- 瘦客户端
我采取以下步骤：
- 打开 Eclipse
- 创建一个新的报告项目
- 添加数据源
- 选择“JDBC 数据源”（也尝试过“查询生成器的 JDBC 数据库连接”）
- 选择“Oracle”连接配置文件类型并单击下一步。
此时，我看到驱动程序列表是空的。这让我觉得很奇怪，但我想也许我必须定义驱动程序定义。因此，我采取以下步骤：
- 单击“定义驱动程序定义”
- 在“名称/类型”选项卡中，选择“Oracle Thin Driver”，系统版本 11
此时，我看到一条错误消息：无法在中找到 JAR/zip驱动程序定义指定的文件系统：ojdbc14.jar。看来我可以找到的 ojdbc14.jar 甚至不存在于我的系统上。
我尝试添加可以在 oracle 客户端目录中找到的其他 jdbc jar 文件（即来自 Oracle_Base\product\11.2.0\client_1\jdbc\lib），但似乎没有任何方法可以解决问题。
帮助？
As an FYI, I'm new to this entire stack, so I might be making a basic error.
I'm attempting to explore BIRT reporting for a Maximo system that was recently upgraded.
To do so, I installed the following:
- Java 6 & Java 7 JDKs
- BIRT version of Eclipse (Eclipse + BIRT plugins built in).
- Some Oracle 11gR2 client options (a custom install)
- SQL*Plus
- JDBC/ODBC drivers
- Thin Client
I take the following steps:
- Open Eclipse
- Create a new Reporting Project
- Add a Data Source
- Select "JDBC Data Source" (also tried "JDBC Database Connection for Query Builder")
- Select the "Oracle" connection profile type and click next.
At this point, I see that the drivers list is empty. This strikes me as odd, but I figure maybe I have to define the driver definition. So I take the following steps:
- Click "Define driver definition"
- In the Name/Type tab, select "Oracle Thin Driver", system version 11
At this point, I see an error message: Unable to locate JAR/zip in file system as specified by the driver definition: ojdbc14.jar. It seems that ojdbc14.jar doesn't even exist on my system that I can find.
I have tried adding other jdbc jar files that I can find in the oracle client directory (i.e. from Oracle_Base\product\11.2.0\client_1\jdbc\lib) but nothing seems to resolve the issue.
Help?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
我有类似的问题。
单击“全部清除”，然后手动添加 jar 解决了问题。
I had similar issue.
Clicking "Clear all" and then adding the jar manually solved the problem.
不幸的是，这种情况下的答案非常简单——关闭并重新打开 Eclipse 后，我毫不费力地删除了驱动程序，添加了另一个驱动程序，然后开始工作。我很快就启动并运行了。
感谢您的帮助！
The answer in this case was unfortunately stupidly simple -- after closing and reopening Eclipse, I had no trouble removing the driver, adding another, and getting to work. I was up and running in no time.
Thanks for all your help!
确保 ojdbc14.jar 文件存在并且位于您的库路径中。当出现选择驱动程序 ojdbc14.jar 的对话框时，只需单击“查找 jar/zip”按钮并查找该文件。
有时它在那里，但仍然不起作用。要解决此问题，请按“全部清除”按钮。现在重复上述过程。将添加 .jar，然后您将继续看到驱动程序连接和详细信息对话框。
Ensure the ojdbc14.jar file exsists and is in your library path. When on the dialog for picking the driver ojdbc14.jar, simply click the find jar/zip button and find the file.
Sometimes it is there, but still does not work. To solve this problem, press the "clear all" button. Now repeat the above process. The .jar will be added and you will continue to driver connection and details dialog box.
发生这种情况是因为 Eclipse IDE 在 eclipse 安装路径中找不到驱动程序。这就是你要做的：
在系统中搜索.jar文件并将其复制到eclipse安装路径。
如果您无法获取它，请访问 http://dev.mysql.com/downloads/connector/j< /a> 并找到所需的连接器。下载并保存到eclipse安装路径下。现在 Eclipse 可以看到它并且错误将不再出现。
This happens because the Eclipse IDE could not find the driver in the eclipse installation path. This is what you will do:
Search for the .jar file in your system and copy it to the eclipse installation path.
If you could not get it visit http://dev.mysql.com/downloads/connector/j and locate the required connector. Download it and save it to the eclipse installation path. So now Eclipse can see it and the error would no longer appear.
非常简单的答案是进入 Jar 控制台，单击编辑 jar，然后再次选择文件系统中的 jar。这将在您的文件系统中简单地定位文件
Very simple answer is Into the Jar Console Click on edit jar and Again select jar in your file system. that will locate file in your file system simple
我必须重新启动 Eclipse 并重新开始以下过程：数据库连接 ->新-> PostgreSQL ->清除全部（JAR 列表）->再次装入罐子。
这样就可以正常工作了。
I had to restart Eclipse and start again with the process: Database Connections -> New -> PostgreSQL -> Clear All (JAR list) -> Load the jar again.
This way it worked correctly.