Could someone help to fix this issue. i enable ssl to connect to a remote database. I use c3p0 properties (last version of c3p0, use maven).
...
...
c3p0.debugUnreturnedConnectionStackTraces=true
c3p0.unreturnedConnectionTimeout=0
c3p0.maxStatementsPerConnection=0
c3p0.idleConnectionTestPeriod=120
c3p0.maxIdleTime=500
c3p0.maxConnectionAge=3000
c3p0.initialPoolSize=2
c3p0.maxPoolSize=225
c3p0.minPoolSize=1
...
...
I use ComboPooledDataSource class in my datasource to set the properties.
To enable ssl, I update my connection string to add useSSL=true, verifyServerCertificate=false and sslMode=REQUIRED then it will include : ...&sslMode=REQUIRED&useSSL=true&verifyServerCertificate=false...
but i got below error :
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) ~[mchange-commons-java-0.2.20.jar!/:0.2.20]
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77) ~[mchange-commons-java-0.2.20.jar!/:0.2.20]
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.ticketmaster.international.health.check.database.AbstractDatabaseHealthCheck.isHealthy(AbstractDatabaseHealthCheck.java:29) ~[health-check-database-4.2.2.jar!/:4.2.2]
... 55 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@6e612122 -- timeout at awaitAvailable()
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1505) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) ~[c3p0-0.9.5.5.jar!/:0.9.5.5]
at com.ticketmaster.international.health.check.database.AbstractDatabaseHealthCheck.isHealthy(AbstractDatabaseHealthCheck.java:29) ~[health-check-database-4.2.2.jar!/:4.2.2]
... 55 more