R RJDBC java.lang.OutOfMemoryError

r memory heap-memory rjdbc
user3567601 picture user3567601 · Jul 11, 2014 · Viewed 13.3k times · Source

I got following error while run dbGetQuery of RJDBC 0.2-4:

Error in .jcall(rp, "I", "fetch", stride) :    
  java.lang.OutOfMemoryError: Java heap space

Following is my code:

Sys.setenv(JAVA_HOME='C:/Program Files (x86)/Java/jdk1.7.0_25')
options(java.parameters='-Xmx1g')
library(rJava)
library(rjson)
library(RJDBC)

# Output Java version
.jinit()
print(.jcall("java/lang/System", "S", "getProperty", "java.version"))

jdbcDriver <<- JDBC(driverClass="oracle.jdbc.OracleDriver", classPath="C:/lib/dashboard_lib/ojdbc6.jar")
jdbcConnection <<- dbConnect(jdbcDriver, "...", "...", "...")
dataset <<- dbGetQuery(jdbcConnection, "select * from OPR_DATA.MV_REG_CTRY_MS_QUARTER_AMT")

Can anyone help me with this, thanks very much in advance

Answer

fc9.30 picture fc9.30 · Jun 28, 2016

Simply change the java.parameters to 8GB before load RJDBC package: 

options(java.parameters = "-Xmx8048m")
library("RJDBC")

Related questions

Determining memory usage of objects?

I'd like to work out how much RAM is being used by each of my objects inside my current workspace. Is there an easy way to do this?

Read More
R: how to rbind two huge data-frames without running out of memory

I have two data-frames df1 and df2 that each have around 10 million rows and 4 columns. I read them into R using RODBC/sqlQuery with no problems, but when I try to rbind them, I get that most dreaded of R …

Read More
R multicore mcfork(): Unable to fork: Cannot allocate memory

I'm getting the titular error: mcfork(): Unable to fork: Cannot allocate memory after trying to run a function with mcapply, but top says I'm at 51% This is on an EC2 instance, but I do have up-to-date R. Does anyone know …

Read More