Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Sql Server Failover Partner

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sql Server Failover Partner

    Hi,

    Does any one know if Mirth supports the SQL 2005 Failover Partner config in the connnection string?

    Thanks

  • #2
    Re:Sql Server Failover Partner

    For Future Reference,

    I installed the microsoft.jdbc driver 1.2 and added the failoverPartner= into the connection string and it worked like a charm.

    Comment


    • #3
      I have added sqljdbc4-2.0.jar file in custom-lib folder and added the driver in dbdrivers.xml file.

      <driver class="com.microsoft.sqlserver.jdbc.SQLServerDrive r" name="SQL Server 2012" template="jdbc:sqlserver://hostort;databaseName=dbName;failoverPartner=dbNa me" selectLimit="SELECT TOP 1 * FROM ?" />

      Used the same driver to call the connection and was able to connect to failoverPartner when primary is down.

      var url = "jdbc:sqlserver://xx.xx.x.xx;DatabaseName=xxx;failoverPartner=xx.xx. x.xx";
      var driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;

      --
      Arun
      Last edited by gouvearun; 09-06-2016, 01:20 AM.

      Comment

      Working...
      X