developerblog.redhat.com developerblog.redhat.com

Connection fail-over if the db-user is locked out

Recently I was facing an issue, the connection pool of datasource was failing to establish a connection with the DB due to account lockout. There are many application servers like Tomcat, JBoss, WebSphere, etc. where you cannot implement the connection pool using multiple users. So, how can we overcome such issue? Yes, the best solution is to configure the db-user to never lockout but this will be against some company security policy...