When a database is down then automatically the ip and port switch to another db server.
How should I configure c3p0 connection pooling of my web apps to follow this Database failover mechanism?
Currently, I am using c3p0, however in the last db failover, pool connections failed to reestablished.
Reestablished after a failing request. Attributes that helps to come over as soon as possible
p:testConnectionOnCheckin="true" p:preferredTestQuery="SELECT @@VERSION"p:acquireRetryAttempts="10"