My system is Mac OS 10.11.5 and has R 3.3.1 and java 1.8.0_92 installed. I have installed XLConnect and XLConnectJars. When I am trying load XLConnect, I get the following error message:
library(XLConnect)
Loading required package: XLConnectJars
JavaVM: requested Java version ((null)) not available. Using Java at "" instead.
JavaVM: Failed to load JVM: /bundle/Libraries/libserver.dylib
JavaVM FATAL: Failed to load the jvm library.
Error : .onLoad failed in loadNamespace() for 'XLConnectJars', details:
call: .jinit()
error: JNI_GetCreatedJavaVMs returned -1
Error: package ‘XLConnectJars’ could not be loaded
I already tried specifying the directory of the java version options(java.home="/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk") as explained in Does XLConnect package work with Java 8?, but this did not solve the problem.