[R] Connection to Oracle DB failing from R

Christofer Bogaso bog@@o@chr|@to|er @end|ng |rom gm@||@com
Mon Aug 31 12:55:48 CEST 2020


Hi,

I am trying to establish a connection to a Oracle DB from R and used below
code which is failing every time I try -

> library(RJDBC)
Loading required package: DBI
> jdbcDriver =JDBC("oracle.jdbc.OracleDriver",classPath="ojdbc5.jar")

 *** caught segfault ***
address 0x854961, cause 'memory not mapped'

Traceback:
 1: .jinit(classPath)
 2: JDBC("oracle.jdbc.OracleDriver", classPath = "ojdbc5.jar")

Possible actions:
1: abort (with core dump, if enabled)
2: normal R exit
3: exit R without saving workspace
4: exit R saving workspace
Selection:


Below is my session info -

> sessionInfo()
R version 4.0.2 (2020-06-22)
Platform: x86_64-apple-darwin17.0 (64-bit)
Running under: macOS Catalina 10.15.6

Matrix products: default
BLAS:
 /Library/Frameworks/R.framework/Versions/4.0/Resources/lib/libRblas.dylib
LAPACK:
/Library/Frameworks/R.framework/Versions/4.0/Resources/lib/libRlapack.dylib

locale:
[1] C/UTF-8/C/C/C/C

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base

other attached packages:
[1] RJDBC_0.2-8  DBI_1.1.0    rJava_0.9-13

loaded via a namespace (and not attached):
[1] compiler_4.0.2

I downloaded the JAR file from
https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html

Can you please help me to understand why it is failing?

	[[alternative HTML version deleted]]



More information about the R-help mailing list