MySQL connection pool problem
Hi,
I'm trying to configure a connection pool to a MySQL database through the OAS Administrator interface. I added the mysql-connector-java-5.0.5-bin.jar file as a shared librairy and added the file manually to the applib directory. But when I try to create the connection pool and test it, this message comes:
An error has occurred.
Unable to create : com.mysql.jdbc.jdbc2.optional.MysqlDataSource
Missing class: com.mysql.jdbc.jdbc2.optional.MysqlDataSource Dependent class: oracle.oc4j.sql.config.DataSourceConfigUtils Loader: oc4j:10.1.3 Code-Source: /C:/product/10.1.3.1/OracleAS_1/j2ee/home/lib/oc4j-internal.jar Configuration: in META-INF/boot.xml in C:\product\10.1.3.1\OracleAS_1\j2ee\home\oc4j.jar This load was initiated at ascontrol.web.ascontrol:0.0.0 using the Class.forName() method. The missing class is available from the following locations: 1. Code-Source: /C:/product/10.1.3.1/OracleAS_1/j2ee/home/applib/mysql-connector-java-5.0.5-bin.jar (from in /C:/product/10.1.3.1/OracleAS_1/j2ee/home/config/server.xml) This code-source is available in loader global.libraries:1.0. This shared-library can be imported by the "ascontrol" application. 2. Code-Source: /C:/product/10.1.3.1/OracleAS_1/j2ee/home/shared-lib/com.mysql.jdbc/5.05/mysql-connector-java-5.0.5-bin.jar (from in /C:/product/10.1.3.1/OracleAS_1/j2ee/home/config/server.xml) This code-source is available in loader com.mysql.jdbc:5.05. This shared-library can be imported by the "ascontrol" application.
I also added manually this line in the orion-application.xml of ascontrol:
<import-shared-library name="com.mysql.jdbc"/>
But the same message keeps coming. Any help would be greatly appreciated.
Amir