找不到JDeveloper MySQL错误驱动程序 [英] JDeveloper MySQL error Driver not found

问题描述

我正在使用最新的wamp服务器运行MySQL数据库.使用Oracle JDeveloper 11g.我将MySQL连接器jar放置在.../jdeveloper/jdev/lib文件夹中，并将该jar作为库添加到我的adf应用程序中. .我能够创建与数据库的连接，可以在JDev的DB Navigator中查看表，还可以创建Entity和View Objects.但是，当我尝试运行应用程序模块时，出现错误弹出窗口，提示无法创建连接，找不到驱动程序.我将ApplicationModule数据源配置设置为JDBC数据源. 帮助！！！ .谢谢

I am running MySQL db using the latest wamp server. Using Oracle JDeveloper 11g. I have placed the MySQL connector jar in .../jdeveloper/jdev/lib folder and added the jar as a library in my adf application . . I am able to create a connection to the db, view the tables in DB Navigator of JDev, also create Entity and View Objects. However when I try to run the Application Module, I get an error popup saying could not create connection, driver not found. I have the ApplicationModule data source configuration set to JDBC Datasource. Help!!! . Thank you

更新: 错误日志-----------------------------

Update : The Error Log-----------------------------

[232] Using the oracle.jbo.server.ConnectionPoolDataSource to acquire a connection...
[233] Creating a new pool resource
[234] Trying connection/3: url='jdbc:mysql:/*****' user='root' password='*****' ...
[235] DBTransactionImpl.initTransaction: Login failed
[236] java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/myDatabase
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:187)
at oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:195) 
at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:166)
at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:580)
at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:313)
at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:102)

---

1. 用于连接到我的数据库的用户名和密码是正确的，我能够在连接管理器中对其进行测试.
2. 我在运行Application Module时遇到此错误，所以我认为Integrated Weblogic Server不在这里.
3. 我已确保在库中将mysql-connector jar标记为默认部署".

推荐答案

还应将jdbc jar文件放在嵌入式WebLogic可以找到它的位置.因此，在JDeveloper的系统目录/users/youruser/roaming/app data/JDeveloper下找到您的defaultDomain目录. 并在其中找到lib目录.

The jdbc jar file should also be placed where the embedded WebLogic can find it. So locate your defaultDomain directory under the JDeveloper's system directory /users/youruser/roaming/app data/JDeveloper And locate the lib directory there.

或确保您在JDeveloper中为JDBC jar创建的库被标记为默认部署".

Or make sure that the library you created in JDeveloper for the JDBC jar is marked as "Deploy by default".

这篇关于找不到JDeveloper MySQL错误驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！