SQLTeam.com | Weblogs | Forums

AlwaysOn high availability and JDBC


#1

I'm coming from an Oracle background where connecting to an Oracle cluster(as opposed to a single Oracle server) is just a matter of changing the JDBC connection string which we use to connect to the database.

Is it the same with SQL server? (version is 2012). If so where can I find some examples of JDBC connection strings for a AlwaysOn environment?


#2

These should help:

https://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/ms378988(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/gg558121(v=sql.110).aspx

Third link specifically addresses the HADR settings to support failover.