locked
configuration failover Partner in JDBC connecting string for SQL Server 2008R2, RRS feed

  • Question

  • Hi all,

    I have a mirroring configuration  in Production environment (SQL Server 2008R2) with high-safety without automatic failover(no witness server)

    Below are the Servers:
    Primary server FQDN is:mssqlprod1.xxxxx.com
    Mirrior server FQDN is:mssqlprod2.xxxxx.com,

    Now we want configure failoverPartner in below connecting string ,which is using JDBC, Please advise.  


    <datasource jndi-name="java:jdbc/codedb" pool-name="mssqlServer" enabled="true" jta="true" use-java-context="true" use-ccm="true">
                        <connection-url>
                            jdbc:sqlserver://mssqlprod.xxxxx.com;databaseName=DB_codes;loginTimeout=30
                        </connection-url>


    Please advise how to configure mirror failoverPartner in connecting string which is using  JDBC 

    Thanks in advance


    SNIVAS


    • Edited by SNIVAS Wednesday, June 8, 2016 11:05 AM correction in db name
    Wednesday, June 8, 2016 11:04 AM

Answers