Justin Holder
2016-Aug-19 11:01 UTC
[R] 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]]