CODEWITHSUNDEEP
mysqlglassfishconnection-pooling
user818700
user818700

Reputation:

Struggling to create MySQL Connection Pool on Glassfish

I've done this before but for some reason I'm really having some difficulty creating this connection pool. When I ping the connection pool after creating it I get this error:

Ping Connection Pool for bondsaver is Failed. 
Ping failed Exception - Class name is wrong or classpath is not set for : com.mysql.jdbc.jdbc2.optional.MysqlDataSource 
    Please check the server.log for more details. 
Ping failed Exception - Class name is wrong or classpath is not set for : com.mysql.jdbc.jdbc2.optional.MysqlDataSource 
    Please check the server.log for more details.

The info I've provided in the creation of the pool is as follows:

Is there anything I've left out? Anything I misspelled or inputted incorrectly?

Thanks in advance!

Upvotes: 4

Views: 6948

Answers (1)

Matt Handy
Matt Handy

Reputation: 30025

Seems to be a classpath issue. Do you have the mysql connector in your domain's lib dir?

The correct path should be:

glassfish-install-dir\glassfish\domains\domain1\lib

(or a different domain name if you don't use the default domain1)

Upvotes: 4

Related Questions