How we can put a fail over connection string pointing to DR site when disaster happens. This will save us steps to make changes to hundreds of JVMs when we have to bring JVMs up on DR site. We need to have minimum possible time to recover and target 0 manual steps when we fail over.

<Resource name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://XXXXX\XXXX:XXXX;integratedSecurity=true;SendStringParametersAsUnicode=false;SelectMethod=cursor;DatabaseName=XXXX1D"
maxActive="100"
maxIdle="30"
maxWait="10000"
/>

So far the only solution we have is to change the servername with the DNS alias and when failover happens change the alias to the fail over SQL server.