Connection to Oracle DB failing from R
Which version of java do you have installed? Oracle's web site says ojdbc5.jar is for Java 1.5 and ojdbc6.jar is for more recent versions. Bill Dunlap TIBCO Software wdunlap tibco.com On Mon, Aug 31, 2020 at 3:56 AM Christofer Bogaso
<bogaso.christofer at gmail.com> wrote:
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]]
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.