Best practices to connect from BusinessWorks to an SQL Server Always On Availability Group

This article outlines the best practices to apply for connecting from BusinessWorks to an SQL Server instance configured with an Always On Availability Group.

Use a recent version of the Microsoft JDBC driver

Microsoft JDBC driver release 13.2.1 is bundled in both: . BusinessWorks 6.12 HF01 . TIBCO Runtime Agent 5.13 HF06

The use of this version is not mandatory but recommended.

Add the following options on the JDBC URL

. multiSubnetFailover=true . connectRetryCount=10 . connectRetryInterval=3 . loginTimeout=30

Example:

jdbc:sqlserver://MyAgListener.domain.com:1433;encrypt=true;trustServerCertificate=true;multiSubnetFailover=true;connectRetryCount=10;connectRetryInterval=3;loginTimeout=30