unable to establish a ConnectionPool with MySQL
Hello all, just some background here. I am able to establish JDBC connections with the db, and can connect using Java Studio Enterprise 8. But, I like the subject states, I can not create a ConnectionPool.
I set up a pool, then try to ping it, and the error I get is...
Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: com.mysql.jdbc.Driver
here are some details:
the mysql driver jar is located at ...\domain\lib\ext directory
Name: mysqla
driver: com.mysql.jdbc.Driver
resource type: javax.sql.DataSource (note: I also get the same error if I use java.sql.XADataSource and java.sql.ConnectionPoolDataSource)
database name: jdbc:mysql://localhost:3306/ejbxp
I also set user and password
everything else is default. Also, on MySQL, max connections is set a 100 so connections shouldn't be an issue.
So, does anybody have any idea what is wrong? Thanks for your time
