I am having trouble getting RJDBC and rJava working. rjava does not
seem to be able to traverse my classpath that I define inside R.
My example is
library(RJDBC)
.jinit('C:\\Libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar')
drv <- JDBC("com.mysql.jdbc.Driver",
'C:\\Libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar'
, identifier.quote ="`")
the call to JDBC and hence the call so jclassPath, cause the following error
Error in JDBC("com.mysql.jdbc.Driver",
"C:\\Libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar",
:
Cannot find JDBC driver class com.mysql.jdbc.Driver
Any help is greatly appreciated.
Thank you
Joe
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
