Message-ID: <DB5PR10MB02617151C29F442514D95A8F95160@DB5PR10MB0261.EURPRD10.PROD.OUTLOOK.COM>
Date: 2016-08-19T11:01:22Z
From: Justin Holder
Subject: RJDBC - Java connection to Oracle database crashing on execution
Hi,
I have a script that starts with some code to open a connection to an Oracle database, however the code is crashing R/RStudio as soon as it runs. The code does run successfully on another machine.
The script opens by loading the required RJDBC package:
library("RJDBC", lib.loc="C:/Program Files/R/R-3.3.1/library")
After, this I run the code below that points to the required ojdbc7.jar file, that should start the connection, however this crashes R, closing it down a few seconds later:
drv = JDBC("oracle.jdbc.OracleDriver",
classPath="C:/Program Files/R/ojdbc7.jar", " ")
The same thing happens in Rstudio - there is no error message, the program simply crashes stating that "R encountered a fatal error . The session was terminated".
Again, the code executes exactly as written on a another machine.I have the latest versions of all required software/packages, so I'm not sure what is causing the crash.
Thanks.
[[alternative HTML version deleted]]