[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