title: How to connect to MS Sql Server failover cluster using Glassfish JDBC connection pooling
body: <p>I'm trying to connect to a failover cluster using the glassfish connection pooling. My resource type is <code>XADataSource</code>, classname <code>JtdsDataSource</code>. My additional properties are:</p>
  
  <ul>
  <li>User</li>
  <li>DatabaseName</li>
  <li>Password</li>
  <li>PortNumber</li>
  <li>serverName</li>
  </ul>
  
  <p>All of these work for connecting normally but I have been unable to find the correct property name for connecting to the mirror for this database. On the basis of this page <a href="https://msdn.microsoft.com/en-us/library/ms175484.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms175484.aspx</a> I've tried  <code>FailoverPartner</code> and <code>Failover_Partner</code> but during testing where the primary database was brought down while the server was running glassfish was still trying to connect to the primary.</p>
  
  <p>With nothing else to go on regarding this particular scenario, I ask what specific property name is used to specify my mirror database in Glassfish.</p>
  
  <p>Thanks in advance.</p>