Search code examples
javasnowflake-cloud-data-platformjnasnowflake-schemasnowflake-connector

Secure Local Storage issue while connecting java with Snowflake

I am receiving this error:

net.snowflake.client.core.CredentialManager initSecureStorageManager

INFO: JNA jar files are needed for Secure Local Storage service. Please follow the Snowflake JDBC instruction for Secure Local Storage feature. Fall back to normal process.

net.snowflake.client.core.CredentialManager fillCachedCredential

INFO: JNA jar files are needed for Secure Local Storage service. Please follow the Snowflake JDBC instruction for Secure Local Storage feature. Fall back to normal process.

How do I add these files in my project?

This is my connection properties files:

hostname=jdbc:snowflake://ya189.ap-south-1.aws.snowflakecomputing.com/
user=
password=
account=ya189.ap-south-1
database=DEMO_DB
role=
warehouse=COMPUTE_WH
schema=PUBLIC
IS_ENCRYPTED=true
authenticator=externalbrowser

I have included JNA in my pom.xml:

<dependency>
    <groupId>net.snowflake</groupId>
    <artifactId>snowflake-jdbc</artifactId>
    <version>3.13.15</version>
</dependency>
<!-- https://mvnrepository.com/artifact/net.java.dev.jna/jna -->
<dependency>
    <groupId>net.java.dev.jna</groupId>
    <artifactId>jna</artifactId>
    <version>5.9.0</version>
</dependency>
<dependency>
    <groupId>net.java.dev.jna</groupId>
    <artifactId>jna-platform</artifactId>
    <version>5.9.0</version>
</dependency>
Solution

  • Connection caching for browser-based SSO and token caching for multi-factor authentication (MFA) require the use of the Java Native Access (JNA) classes to save data securely to the filesystem.

    As of version 3.12.18 of the JDBC Driver, the JNA classes are no longer packaged in the JDBC Driver JAR file. In the JDBC Driver pom.xml file, the dependencies on these classes are marked as optional.

    If you need to use connection caching or token caching, you must add the following libraries to your classpath.

    The pom.xml file for the JDBC Driver specifies the version of the JNA classes that have been tested with the JDBC Driver. We recommend using this version (or the same major version) of the JNA classes.

    For more information read here