java - Why does the Microsoft JDBC driver ignore the failoverPartner host name -
java - Why does the Microsoft JDBC driver ignore the failoverPartner host name -
the microsoft jdbc driver v4 seems ignore configured failoverpartner
host name. connection string looks follows:
jdbc:sqlserver://primary-host:1433;database=ms-sql-db;failoverpartner=secondary-host
yet, when primary host offline driver unable connect secondary host:
com.microsoft.sqlserver.jdbc.sqlserverexception: tcp/ip connection host foo4711, port 1433 has failed
notice how host name in exception not match host name in connection string ('secondary-host' vs. 'foo4711'). 'foo4711' name of physical machine while 'secondary-host' name machine listed under in /etc/hosts
. 'foo4711' cannot resolved ip in our setup.
so, why driver not utilize host name given in connection string?
java sql-server jdbc
Comments
Post a Comment