Coldfusion 2011 / 2018 Datasource to MSSQL AG Failover DB

Question

Hi.

We have set up a SQL 2017 failover cluster (active/passive).

We have created the datasource in ColdFusion to the IP of the AG database and it's all OK.

If i switch the SQL servers all old request from coldfusion remain suspended (new request go to the active server).

I found in MS documentation how to set JDBC driver in HA:

https://docs.microsoft.com/en-us/sql/connect/jdbc/jdbc-driver-support-for-high-availability-disaster-recovery?view=sql-server-ver15

But it seems that it cannot be done with the native coldfusion JDBS driver for MSSQL.

I've to use the MS JDBC Driver (acctual version 7.4.1.0)?

It's supported?

Or there's a way to use the multiSubnetFailover in the coldfusion native driver?

Dave Watts · Answer

You can certainly use Microsoft's own JDBC drivers instead of the ones that come with CF. You may find that they don't work as well - or you may find that they work better! You can just drop the appropriate JAR files in the right place, and use "Other" in the JDBC dropdown selector for the database driver as described here:

https://helpx.adobe.com/coldfusion/configuring-administering/data-source-management-for-coldfusion.html#Connectingtootherdatasources

To actually put the JDBC driver file in the right place, you can use this as a guide. It's for Oracle, but the process is basically the same:

https://helpx.adobe.com/coldfusion/kb/coldfusion-mx-configuring-oracle-jdbc-1.html

If you want to use the built-in CF drivers, they're made by DataDirect, and that's where you'd go to figure out if you can do clustering:

https://www.progress.com/documentation/datadirect-connectors?ds=microsoft-sql-server&interface=jdbc

Dave Watts, Eidolon LLC

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded