SunOne Studio / Appserver7 and MysqlDataSource

[Tom Valine]

I'm trying to port the BookDB example in the j2ee tutorial to mysql from
pointbase. I'm using com.mysql.jdbc.jdbc2.optional.MysqlDataSource for the
connection pool. I can access the mysql server using
org.gjt.mm.mysql.Driver, but when I try to set it up as a JNDI resource, I
get the standard "access denied for user root@host (Using password: YES).
For the connection pool, I have setup the user, password , databaseName,
serverName and port variables. If anyone has successfully set up a mysql
database connection pool in appserver7 using MysqlDataSource, please let me
know how you did it

The versions I'm using can be found at www.ohrasys.com/JDBCDriverTest which
is incidentally the example I used to prove that using the
org.gjt.mm.mysql.Driver access method with the same username and password
does indeed work.