Data Quality Dashboard Dependency Question: What operating system, version of Java, and version of R are you able to get DatabaseConnector to work on?

Implementers
1

Hi Everybody,

DatabaseConnector is a dependency of Data Quality Dashboard:

If you are able to get DatabaseConnector to work, What operating system (Windows or Mac), version of Java, and version of R (64bit or 32bit) are you using?

I’m still having issues getting DatabaseConnector to work in R. I’m running the following and getting the error shown below.

install.packages("devtools")
install.packages("rJava")
devtools::install_github("OHDSI/DatabaseConnector")
# devtools::install_github("OHDSI/SqlRender")

---------------
ERROR
---------------

** building package indices
** installing vignettes
   'UsingDatabaseConnector.Rmd' using 'UTF-8' 
** testing if installed package can be loaded from temporary location
*** arch - i386
Error: package or namespace load failed for 'DatabaseConnector':
 .onLoad failed in loadNamespace() for 'rJava', details:
  call: library.dynam("rJava", pkgname, libname)
  error: DLL 'rJava' not found: maybe not installed for this architecture?
Error: loading failed
Execution halted
*** arch - x64
ERROR: loading failed for 'i386'
* removing 'C:/ProgramData/R/lib/DatabaseConnector'

The full session is shown in the attached file (the file was renamed to pdf but is really a text file, rename to .txt to read). This is related to this issue: Question about error in R trying to install DatabaseConnector

database-connector-output.pdf (78.9 KB)

2

I was able to get this to run

install.packages("devtools")
install.packages("rJava", INSTALL_opts = "--no-multiarch")
devtools::install_github("OHDSI/DatabaseConnector", INSTALL_opts = "--no-multiarch")
devtools::install_github("OHDSI/SqlRender", INSTALL_opts = "--no-multiarch")

Using these versions:
Windows 10
Java “17.0.2” 2022-01-18 LTS
R 62bit default

I also needed to run RStudio as “admin” to get it to run correctly.

3

This is the best installation guide:

https://ohdsi.github.io/Hades/rSetup.html

4

Beautiful, Thanks Ajit!