Install rJava and RJDBC Libraries

This topic explains how to install rJava and RJBDC libraries.

Problem

When you install rJava and RJDBC libraries with the following command in a notebook cell:

install.packages(c("rJava", "RJDBC"))

You observe the following error:

ERROR: configuration failed for package 'rJava'

Cause

The rJava and RJDBC packages check for Java dependencies and file paths that are not present in the Azure Databricks R directory.

Solution

Follow the steps below to install these libraries on running clusters.

  1. Run following commands in a %sh cell.

    %sh
    ls -l /usr/bin/java
    ls -l /etc/alternatives/java
    ln -s /usr/lib/jvm/java-8-openjdk-amd64 /usr/lib/jvm/default-java
    R CMD javareconf
    
  2. Install the rJava and RJDBC packages.

    install.packages(c("rJava", "RJDBC"))
    
  3. Verify that the rJava package is installed.

    dyn.load('/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/amd64/server/libjvm.so')
    library(rJava)