R MySQL connection error rJAVA -
when trying establish connection between mysql database , rserver:
driverdir <- "~/drivers/mysql-connector-java-5.1.44/" driver <- jdbc(driverclass = "com.mysql.jdbc.driver", classpath = file.path(driverdir, "mysql-connector-java-5.1.44-bin.jar"), "`") constr_unhashed <- getvar_("constr_unhashed") username <- getvar_("uid") password <- getvar_("pwd") conn_unhashed <- trycatch(dbconnect(driver, constr_unhashed, username, password), error = function(e) {flog.error(e); "error"})
i getting error:
error in ._jobjref_dollar(x[["jobj"]], name) : no field, method or inner class called '.when'
for pointed out rjava github repo have tested java version , r java versions:
~/drivers$ java -version bash: [: 455 java -version: integer expression expected bash: [: 455 java -version: integer expression expected java version "1.8.0_101" java(tm) se runtime environment (build 1.8.0_101-b13) java hotspot(tm) 64-bit server vm (build 25.101-b13, mixed mode) ~/drivers$ r cmd javareconf bash: [: 456 r cmd javareconf: integer expression expected bash: [: 456 r cmd javareconf: integer expression expected *** java_home not valid path, ignoring java interpreter : /usr/bin/java java version : 1.8.0_101 java home path : /usr/lib/jvm/java-8-oracle/jre java compiler : /usr/bin/javac java headers gen.: /usr/bin/javah java archive tool: /usr/bin/jar
any suggestion on might missing?
Comments
Post a Comment