search cancel

Load JDBC driver class [net.snowflake.client.jdbc_SnowflakeDriver] error when creating connection profile

book

Article ID: 255088

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When creating a connection profile in the TDM Portal for Snowflake DB, the following error pops up:
The server replied: Could not load JDBC driver class [net.snowflake.client.jdbc_SnowflakeDriver]; nested exception is java.sql.SQLException

Environment

Release : 4.10

Cause

The error message "Could not load JDBC driver class [net.snowflake.client.jdbc.SnowflakeDriver]" indicates that TDM does not have access to the JDBC driver for Snowflake. 

Resolution

The driver can be downloaded as a jar with a name similar to: snowflake-jdbc-#.#.#.jar
Please see:
https://docs.snowflake.com/en/user-guide/jdbc-download.html

After downloading the jar, place it in the Tomcat lib folder for TDM. 
By default this folder is:  C:\Program Files\CA\CA Test Data Manager Portal\tomcat\lib