ColdFusion not maintaining connection to Azure Data Warehouse| View in Tracker
Failure Type: Usability Issue
Found In Build/Fixed In Build: 2016.0.05.303689 /
Priority/Frequency: Normal / All users will encounter
Locale/System: English / Win 2012 Server x64
Vote Count: 0
Problem Description: Our ColdFusion 2016 Enterprise server (Windows Server 2012 R2) is not maintaining connections to a Microsoft Azure Data Warehouse. The first Azure query on a page takes a second or more to run. Subsequent Azure queries on the same page take a fraction of a second example: test1 (Datasource=azureDev, **Time=3485ms**, Records=1) in D:\DW\dwtest\CF2016\bob\azureAdhoc.cfm @ 12:10:12.012 select count(*) cnt from dimpatient where name like 'smith%' and birthdate >'2014-02-01' test2 (Datasource=AzureDev, **Time=125ms**, Records=3) in D:\DW\dwtest\CF2016\bob\azureAdhoc.cfm @ 12:10:12.012 select * from dbo.dimPatientMergeStatus test3 (Datasource=azureDev, **Time=281ms**, Records=1) in D:\DW\dwtest\CF2016\bob\azureAdhoc.cfm @ 12:10:13.013 select count(*) cnt from dimpatient where name like 'jones%' and birthdate >'2004-02-01' It is apparent that CF is taking extra time to actually make the connection each time while running the first query on the page. We've tried with various queries and re-arranging their order and always end up with the same result. We are connecting to Azure Data Warehouse using the latest MS jdbc driver (mssql-jdbc-6.2.2.jre8.jar) and 'Maintain Connections' is checked. We first attempted to connect using the built in Microsoft SQL Server driver but kept getting this error: Connection verification failed for data source: AzureDev2 java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error fetching requested database meta-data info. We do not see this issue when we run the queries in SSMS. We do not have this issue with any of our (many) other data sources.