1

I'm trying to connect to oracle DB from R in Mac (El Capitan) using RJDBC connector . I downloaded the driver, ojdbc6.jar from Oracle Driver.

In my R, I setup

$ Sys.setenv(JAVA_HOME='/usr/libexec/java_home')
$ options(java.parameters="-Xmx2g")
$ library(rJava)
$ library(RJDBC)
$ oDriver = JDBC(driverClass="oracle.jdbc.OracleDriver", classPath="ojdbc6.jar")

I get error

Error in .jfindClass(as.character(driverClass)1) : class not found

I've also setup in my .bash_profile

$ export ORACLE_HOME=/Library/Oracle/instantclient_11_2 export
$ DYLD_LIBRARY_PATH=$ORACLE_HOME/lib export
$ LD_LIBRARY_PATH=$ORACLE_HOME
$ export TNS_ADMIN=$ORACLE_HOME/network/admin export
$ PATH="/Library/Oracle/instantclient_11_2:$PATH"

I'm not sure what else I'm missing. Any help would be appreciated.

Thanks.
Hash

Hash
  • 11
  • 2
  • Off from the OP, but have you considered the ROracle library? https://cran.r-project.org/web/packages/ROracle/index.html – Beege Mar 11 '16 at 17:30
  • I tried that too, but I'm getting someother error in it. I followed the steps mentioned in [link](http://stackoverflow.com/questions/5550977/installing-roracle-on-mac-os-x-what-is-needed-from-oracle). Even then I get `Error in dyn.load(file, DLLpath = DLLpath, ...) : unable to load shared object '/Library/R/3.2/library/ROracle/libs/ROracle.so':` – Hash Mar 11 '16 at 23:18
  • Hi, I'm looking for some suggestions. I'd really appreciate any help. Thanks. – Hash Mar 14 '16 at 14:53
  • aha! I solved the problem by reconfiguring java using `R CMD javareconf` and reinstalling `rJava`. This solved the problem. – Hash Mar 14 '16 at 19:28

0 Answers0