[R] RJDBC and rjava

[Joe W. Byers]

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