Amrit Nepal wrote:
> Hi,
>
> I am trying to setup jndi connection pool in sun
> AS (ver 8.1) to link to MySql (ver 4.1). I have
> set this up as:
> Datasource classname: com.mysql.jdbc.Driver
> Resource type: javax.sql.DataSource
>
> When hitting Ping, I get "Operation
> 'pingConnectionPool' failed in 'resources' Config
> Mbean. Target exception message:
> com.mysql.jdbc.Driver".
>
> Any idea?
>
> Thanks
Amrit,
com.mysql.jdbc.Driver is not an implementation of javax.sql.DataSource. My guess is you want to use com.mysql.jdbc.jdbc2.optional.MysqlDataSource (which implements javax.sql.DataSource), _or_ com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource (which implements javax.sql.ConnectionPoolDataSource, so thuis you'd have to change your "Resource type" accordingly).
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html