r语言 - ERROR: java.lang.NoClassDefFoundError: Could not initial

Question

我使用R Studio连接到Snowflake使用这个代码

# Get JDBC Driver
#Mention the classPath as where your downloaded jdbc jar file is present.
jdbcDriver <- JDBC(driverClass="net.snowflake.client.jdbc.SnowflakeDriver",
classPath="/Users/EWorsh/Downloads/snowflake-jdbc-3.13.19.jar")

，我收到这个错误:

Error in JDBC(driverClass = "net.snowflake.client.jdbc.SnowflakeDriver",  : 
java.lang.NoClassDefFoundError: Could not initialize class com.snowflake.client.jdbc.SnowflakeDriver

我正在使用java版本"1.8.0_333";我已经尝试了所有我能找到的故障排除方法。

Answer 1

我刚刚尝试了Java 11与Snowflake JDBC连接器3.13.19，其工作良好，并成功地与R studio连接。

步骤:

> options(dplyr.jdbc.classpath = "/Users/sghosh/JDBC jar/snowflake-jdbc-3.13.19.jar")
> jdbcDriver <- JDBC(driverClass="net.snowflake.client.jdbc.SnowflakeDriver", classPath="/Users/sghosh/JDBC jar/snowflake-jdbc-3.13.19.jar")
> jdbcConnection <- dbConnect(jdbcDriver, "jdbc:snowflake://<account>.snowflakecomputing.com:443/?account=sfcsupport2&warehouse=WH_NAME&db=SAMPLEDATABASE&schema=TEST&tracing=All&jdbc_query_result_format=JSON&role=ADMIN", "sujanT1","password")
> tm=proc.time()
> result <-dbGetQuery(jdbcConnection, 'select * from EMPLOYEE')
> print(result)
ID  NAME AGE SALARY
1  1 sujan 100    200
2  2  alok 500    600

请尝试使用Java 11。