Hi, i try to create a new MySQL JDBC connection pool from the admin GUI but
it fails every time.
I use: javax.sql.ConnectionPoolDataSource and
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
I have setup Glassfish with MySQL JDBC connectionpools a hundred times
without problems, but with this glassfish version it fails over and over.
When I copy the whole connection-settingspart from another glassfish
installation to this server's domain.xml it works without any complaints.
The server.log is very vague about the error:
[#|2013-11-21T16:47:57.486+0100|SEVERE|glassfish3.1.2|org.glassfish.admingui
|_ThreadID=372;_ThreadName=Thread-2;|RestResponse.getResponse() gives
FAILURE. endpoint =
'
https://localhost:4848/management/domain/resources/jdbc-connection-pool';
attrs = '{allowNonComponentCallers=false, connectionValidationMethod=table,
statementTimeoutInSeconds=-1, connectionLeakReclaim=false,
maxConnectionUsageCount=0, associateWithThread=false,
matchConnections=false, name=test_jdbc,
datasourceClassname=com.ddtek.jdbcx.mysql.MySQLDataSource,
failAllConnections=false, isConnectionValidationRequired=false,
maxWaitTimeInMillis=60000, poolResizeQuantity=2, ping=false,
isIsolationLevelGuaranteed=true, lazyConnectionAssociation=false,
Description=null, connectionCreationRetryIntervalInSeconds=10,
connectionCreationRetryAttempts=0, wrapJdbcObjects=true,
lazyConnectionEnlistment=false, statementLeakReclaim=false,
statementCacheSize=0, idleTimeoutInSeconds=300, driverClassname=null,
statementLeakTimeoutInSeconds=0, steadyPoolSize=8,
nonTransactionalConnections=null, connectionLeakTimeoutInSeconds=0,
pooling=true, maxPoolSize=32, validateAtmostOncePeriodInSeconds=0,
resType=javax.sql.ConnectionPoolDataSource}'|#]