library('RJDBC')..." /> library('RJDBC')..." /> library('RJDBC')..."/>

executing library('RJDBC') on R console shows java 6 installation message

566 Views Asked by At

I'm trying to access a mysql database through R console using RJDBC in a mac os X system, but R console crash just after type in " > library('RJDBC') ". Immediately shows up a message indicating is necessary install the old Java 6 mac os version.

I already installed the package typing " > install.packages('RJDBC', dependencies=TRUE) "

My system have: OSX = Mac Os X (Yosemite) R version 3.1.2 (2014-10-31) java 7 installed and set JAVA_HOME env variable in my ./bash_profile file.

echo $JAVA_HOME
/Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home

And also if it is useful

R CMD javareconf
Java interpreter : /Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home/jre/bin/java
Java version     : 1.7.0_60
Java home path   : /Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home
Java compiler    : /Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home/bin/javac
Java headers gen.: /Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home/bin/javah
Java archive tool: /Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home/bin/jar
System Java on OS X

trying to compile and link a JNI progam 
detected JNI cpp flags    : -I/System/Library/Frameworks/JavaVM.framework/Headers
detected JNI linker flags : -framework JavaVM
clang -I/Library/Frameworks/R.framework/Resources/include -DNDEBUG -I/System/Library/Frameworks/JavaVM.framework/Headers -I/usr/local/include -I/usr/local/include/freetype2 -I/opt/X11/include    -fPIC  -Wall -mtune=core2 -g -O2  -c conftest.c -o conftest.o
conftest.c:1:10: fatal error: 'jni.h' file not found
#include <jni.h>
         ^
1 error generated.
make: *** [conftest.o] Error 1
Unable to compile a JNI program


JAVA_HOME        : /Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home
Java library path: 
JNI cpp flags    : 
JNI linker flags : 
Updating Java configuration in /Library/Frameworks/R.framework/Resources
Done.

What Am I doing wrong? I even checked an old post how to get rJava 0.9-3 to work on OS X 10.7.4 with Oracle Java 1.7? and the http://mailman.rz.uni-augsburg.de/pipermail/stats-rosuda-devel/ but I haven't been able to make it work, Does anyone can help me?

1

There are 1 best solutions below

0
On

Not sure if you figured this out yet, but you need to install Java for OS X 2014-001, which is found here...