R help - Oct 2012 - rJava Out of Memory Error

I'm running XLConnect 0.2-1 that depends on rJava 0.9-3. I am only able to
work with 2 workbooks before I get this error...
> SppRich = wb["SpeciesRichness"]     # This command calls an Excel
> spreadsheet
Error: OutOfMemoryError (Java): GC overhead limit exceeded

I have tried...
> rm(list = ls())
... to clear the workspace, but it doesn't help. I am using RStudio 0.96.331
to run R 2.15.1 on a 64-bit Windows platform. Is there a command to dump the
memory used by rJava? I have been re-starting RStudio every 15-min ro so to
continue working. It's a little annoying.

Thanks,
MVS



--
View this message in context:
http://r.789695.n4.nabble.com/rJava-Out-of-Memory-Error-tp4647881.html
Sent from the R help mailing list archive at Nabble.com.

Hi Matthew,

The problem is that the underlying JVM is running with a fixed maximum heap
size. When you load a workbook in XLConnect, an in-memory representation of
that workbook is created (in Java by Apache POI). Reading and writing data
additionally requires memory due to "communication" of your data from
and to
the JVM. Depending on the size of your workbooks and the data you are
dealing with you may need to increase the maximum heap size available to the
JVM. Please have a look at our FAQ at
http://www.mirai-solutions.com/site/index.cfm?id_art=69890&actMenuItemID=31456&plainerr=yes&vsprache=EN
on how to do this.

Other functions that you might be interested in are xlcMemoryReport and
xlcFreeMemroy.

Hope that helps.

Best regards,
Martin




--
View this message in context:
http://r.789695.n4.nabble.com/rJava-Out-of-Memory-Error-tp4647881p4648170.html
Sent from the R help mailing list archive at Nabble.com.