javaroracle-databasecrashrjdbc

RJDBC, Java connection to Oracle database crashing


I have a script that opens with some code to start a connection to an Oracle database, however the code is crashing RStudio as soon as it runs. The exact code was run successfully on another machine previously.

The script opens by loading the required RJDBC package:

library("RJDBC", lib.loc="C:/R/library")

After, this I run the code below:

drv = JDBC("oracle.jdbc.OracleDriver", classPath="C:/R/ojdbc7.jar", identifier.quote = " ")

however this crashes Rstudio - there is no error statement, the program simply crashes stating that "R encountered a fatal error . The session was terminated." When I attempt run this at the command line in regular R (not RStudio) it crashes also.

If this is being caused by some conflict between R and machine, is there a way to determine what is causing it?

Thanks


Solution

  • I had exactly the same problem, having just upgraded my Java distribution from v6 to v8 (both Java Runtime and Java Developer Kit, running on Windows 7). I don't what the reason is, but after reinstalling v6 (and keeping v8), the problem was resolved.