L

Friday, December 18th, 2020 10:15 PM

SFTrustManager initialization error on Snowflake JDBC

Hi all,

Can I ask if anyone had experience on fixing snowflake JDBC issue? We were trying to use Snowflake JDBC v3.12.9 to setup a connection, but got this error:

Error during JDBC database connection: java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.core.SFTrustManager

I’d very much appreciate If anyone could help on solving this or pointing out a direction.

Thank you!

70 Messages

3 years ago

Hi Li,

Is this connection being set up via the Catalog? then you must be using the JDBC driver from Collibra and the correct driver class name is different from what you’re using. Please try following the guide here - https://productresources.collibra.com/docs/user/5.7/#Catalog/RegisterDataSource/JDBC/ref_db-connection-details-collibra-provided-driver.htm?catalog-connector-details=data-sources/catalog-connectors.snowflake

I would also check to see if the version of your Snowflake instance is compatible with the JDBC driver.

Cheers

2 Messages

Hi Pranay,

thank you for your suggestion. However, we are using JDBC driver provided by Snowflake since it is also used in our other BI applications, and I would assume it should function similarly since it’s provided by snowflake itself. Please correct me if it’s not true.

Thank you!

Regards,
Li

70 Messages

Hi Li,

If possible, I would try to get the version of the Snowflake driver from the Collibra marketplace here - https://marketplace.collibra.com/listings/jdbc-driver-for-snowflake-provided-by-snowflake/

Note that though it says it’s a paid driver, this isn’t a custom CData driver. It’s the native driver from Snowflake themselves but has been certified to Sample and Profile metadata. Please try this and follow the instructions listed above. I would open a support ticket if you run into any issues.

Thanks

Loading...