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:
https://www.inetsoftware.de/documentation/jdbc-driver/ms-sql/manual.html#failover

Get in touch today to see how WDCi can help your business.