HHH000339:无法获取连接元数据net.snowflake.client.jdbc.SnowflakeLoggeF

Question

连接雪花时在春季启动中出现异常：**

```2021-12-22 17:14:24.956  WARN 43624 --- [           main] o.h.e.j.e.i.JdbcEnvironmentInitiator     : HHH000339: Could not obtain connection metadata: net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException
net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException: null
at net.snowflake.client.jdbc.SnowflakeDatabaseMetaData.getSQLStateType(SnowflakeDatabaseMetaData.java:2774) ~[snowflake-jdbc-3.13.12.jar:3.13.12]```

连接详细信息：

spring.datasource.password={}
spring.datasource.driverClassName=net.snowflake.client.jdbc.SnowflakeDriver
spring.datasource.url=jdbc:snowflake://{}.snowflakecomputing.com/? 
private_key_file=&private_key_file_pwd=&db=&warehouse=&schema=public
spring.jpa.properties.hibernate.dialect=com.example.demo_snowflex_springboot.EmptyDialect
spring.jpa.properties.hibernate.jdbc.batch_size=10
spring.jpa.properties.hibernate.order_inserts=true
spring.jpa.hibernate.naming.physical- strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl```

Answer 1

我已经将启动器父版本(spring-boot启动器父版本(降级为2.2.5.RELEASE，并可以进行连接。不确定根本原因。

Answer 2

尝试以下配置：

spring.datasource.username=${snowflake.username}
spring.datasource.password=${snowflake.password}
spring.datasource.driverClassName=net.snowflake.client.jdbc.SnowflakeDriver
spring.datasource.url=jdbc:snowflake://${snowflake.account}.snowflakecomputing.com/?warehouse=${snowflake.warehouse}&db=${snowflake.database.name}&schema=${snowflake.schema}&TIMEZONE=${snowflake.timezone:UTC}&CLIENT_RESULT_COLUMN_CASE_INSENSITIVE=true&CLIENT_TIMESTAMP_TYPE_MAPPING=TIMESTAMP_NTZ

spring.jpa.properties.hibernate.dialect=my.company.repositories.EmptyDialect
spring.jpa.properties.hibernate.jdbc.batch_size=10
spring.jpa.properties.hibernate.order_inserts=true