CODEWITHSUNDEEP
jdbcmulesnowflake-cloud-data-platform
Nikhil Udayakumar
Nikhil Udayakumar

Reputation: 21

error while connecting to snowflake via JDBC

I am trying to connect to snowflake via JDBC from mule and we are getting the below error.

: Cannot create JDBC driver of class 'net.snowflake.client.jdbc.SnowflakeDriver' for connect URL 'jdbc:snowflake://cisco.us-east-1.snowflakecomputing.com/?user=XXXXXX&warehouse=XXXXXXX&db=XXXX&schema=XXXXXX&role=XXXX&CLIENT_SESSION_KEEP_ALIVE=true&password=XXXXXXXXX

Error:-

enter image description here

enter image description here

Can some one help to resolve the above issue.

: Cannot create JDBC driver of class 'net.snowflake.client.jdbc.SnowflakeDriver' for connect URL

Root Exception stack trace: java.sql.SQLException: No suitable driver

Please help to resolve the issue.

Upvotes: 0

Views: 3671

Answers (1)

abdatastory
abdatastory

Reputation: 11

Please try below options

Option 1 - Try both the minimum form (e.g. xy12345) and the full account name (e.g. xy12345.east-us-2.azure, but without .snowflakecomputing.com), making sure to not include the jdbc:snowflake:// string.

https://docs.snowflake.com/en/user-guide/jdbc-configure.html

Option 2 - Verify your driver version. Download the driver ( if not ) as per steps and try again

https://docs.snowflake.com/en/user-guide/jdbc-download.html

Upvotes: 0

Related Questions