Failover Support for MSSQL JDBC Driver

If you are integrating with Microsoft SQL Server, you can configure the failover option using the following JDBC drivers:   Microsoft JDBC Driver (Free) Parameter: 1. failoverPartner Connection URL: jdbc:sqlserver://<hostname1>;DatabaseName=<dbname>;failoverPartner=<hostname2_for_failover> More details on setting the connection properties: https://msdn.microsoft.com/en-us/library/ms378988.aspx   Inet (Paid) Parameters: 1. failover=true 2. failoverhost Connectin URL: jdbc:inedae7:<hostname1>?database=<dbname>&failover=true&failoverhost=<hostname2_for_failover> More details can be found at:…

Read More