遇到SQL错误：net。雪花。客户jdbc。SnowflakeSQLException：语句已关闭

Question

我正在使用snowflake jdbc驱动程序（版本：3.12.9）以编程方式执行查询。在snowflake客户端中执行查询正在工作。如果以编程方式执行相同的查询，则会出现以下异常，

select count(*) as total_record_count from TABLE_NAME

    
WARNING|02-10 04:14:25|SessionErrorInterceptor.retrieveSessionId|Trying to reconnect, due to error getting session id: SQL compilation error: error line 1 at position 7
invalid identifier 'CURRENT_SID'
SEVERE|02-10 04:14:26|SessionErrorInterceptor.retrieveSessionId|Error determining session id
net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: error line 1 at position 7
invalid identifier 'CURRENT_SID'
    at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowExceptionSub(SnowflakeUtil.java:153)
    at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowException(SnowflakeUtil.java:77)
    at net.snowflake.client.core.StmtUtil.pollForOutput(StmtUtil.java:503)
    at net.snowflake.client.core.StmtUtil.execute(StmtUtil.java:380)
    at net.snowflake.client.core.SFStatement.executeHelper(SFStatement.java:582)
    at net.snowflake.client.core.SFStatement.executeQueryInternal(SFStatement.java:266)
    at net.snowflake.client.core.SFStatement.executeQuery(SFStatement.java:202)
    at net.snowflake.client.core.SFStatement.execute(SFStatement.java:877)
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:273)
    at net.snowflake.client.jdbc.SnowflakePreparedStatementV1.executeQuery(SnowflakePreparedStatementV1.java:181)
    
WARNING|02-10 04:14:26|SessionErrorInterceptor.createDecorator|Could not determine session information for statement: com.nielsen.datalink.common.jdbc.pool.SessionErrorInterceptor$StatementProxy[Proxy=243720187; Connection=ProxyConnection[PooledConnection[net.snowflake.client.jdbc.SnowflakeConnectionV1@22bf6bee]]; Delegate=net.snowflake.client.jdbc.SnowflakeStatementV1@c32145; Sql=null]
INFO|02-10 04:14:26|SessionErrorInterceptor$StatementProxy.invoke|[session=null] Executing SQL: 

select count(*) as total_record_count from RIM

WARNING|02-10 04:14:26|SessionErrorInterceptor$StatementProxy.invoke|Encountered SQL error: net.snowflake.client.jdbc.SnowflakeSQLException: Statement is closed.
    at net.snowflake.client.jdbc.SnowflakeStatementV1.raiseSQLExceptionIfStatementIsClosed(SnowflakeStatementV1.java:152)
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeUpdateInternal(SnowflakeStatementV1.java:214)
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeLargeUpdate(SnowflakeStatementV1.java:206)
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeUpdate(SnowflakeStatementV1.java:193)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    

谷歌了这个例外，没有找到一个链接。

我也得到了这些错误代码：[0A00020024]

这是我的连接url:jdbc:snowflake://account.xxx.azure.snowflakecomputing.com/?db=DB_NAME

我正在传递上述URL中的所有有效名称，并且我正在传递正确的用户名和密码。

我正在使用JDK 1.8

Answer 1

当查询在Snowflake Web UI上运行正常并且在使用连接器（JDBC、ODBC、Python等）时遇到问题时，要检查的事情之一是网络上的数据包检查器等是否干扰了来自连接器的HTTPS流量。您可以下载并运行SnowCD（连接诊断）来检查此问题。

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

如果SnowCD报告任何问题，您可以运行select system$whitelist（） 要获得所有DNS条目的列表，网络团队需要绕过数据包检查。

https://docs.snowflake.com/en/sql-reference/functions/system_whitelist.html