SQL Server DB - support SQL Server Mirroring?
Answered
Is there any issue using a mirrored SQL Server connection - ie where jdbc connection string includes failoverPartner parameter ala:
https://blogs.msdn.microsoft.com/psssql/2008/12/31/sql-2005-jdbc-driver-and-database-mirroring/
Seems to be in jdbc standard for quite some time, but wanted to confirm if it is supported.
Please sign in to leave a comment.
Hello,
As described here (http://technet.microsoft.com/en-us/library/aa342332(v=sql.110).aspx) application may require some changes to handle connection failure. We did not test this case with TeamCity and at the moment we can't guarantee it will work properly. I'd say that having validation query set for connection should help determining whether connection is broken or not. We have validation query enabled by default, so my guess is that TeamCity should work properly in this case, but since we did not test it we can't guarantee.