R RJDBC java.lang.OutOfMemoryError

Question

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

Have you tired to make increase the memory to 4g instead of 1g. I mean set options for the java parameters to be -Xmx4g instead of -Xmx1g — salhin
– salhin, Commented Oct 29, 2014 at 17:35

fc9.30 · Accepted Answer · 2016-06-28 12:49:28Z

21

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

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

answered Jun 28, 2016 at 12:49

fc9.30

2,61123 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sam · Accepted Answer · 2018-03-16 13:03:25Z

5

It would fail for me using:

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

However,

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

worked.

answered Mar 16, 2018 at 13:03

Sam

5188 silver badges9 bronze badges

Comments

msanford · Accepted Answer · 2017-07-12 14:07:23Z

4

You can increase the memory as below and restart your Rstudio and it worked for me.

memory.limit(size=10000000000024)

edited Jul 12, 2017 at 14:07

msanford

12.4k13 gold badges73 silver badges100 bronze badges

answered Jul 12, 2017 at 12:01

Nages

7931 gold badge9 silver badges13 bronze badges

Comments

leesah anders · Accepted Answer · 2021-01-27 15:31:02Z

1

Commenting in case anyone else comes across this thread with the same error. Updating RJDBC (install.packages("RJDBC")) worked for me.

answered Jan 27, 2021 at 15:31

leesah anders

111 bronze badge

Collectives™ on Stack Overflow

R RJDBC java.lang.OutOfMemoryError

4 Answers 4

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Related