Connection Test for Snowflake DB error U02012064 No driver found

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Setting up a generic JDBC driver for use in connecting to a Snowflake database. When selecting Test Connection, it fails with the error message:

U02012064 No driver found

 

Cause

Incorrect JDBC connection URL specified

Resolution

When setting the connection string for a Snowflake database, the correct syntax (per the Snowflake documentation) is:

jdbc:snowflake://<account_identifier>.snowflakecomputing.com/?<connection_params>

The issue was that the question mark between   .com/ and the connection parameters (for instance warehouse=) was missing, so it looked like

jdbc:snowflake://<account_identifier>.snowflakecomputing.com/warehouse=stage

when it should have been

jdbc:snowflake://<account_identifier>.snowflakecomputing.com/?warehouse=stage

As soon as the question mark was added to the connection string, the connection was successful.

Additional Information

Snowflake documentation link