Message Boards Message Boards

Increase the maximum number of items allowed in a SQL response?

Michael Stern
Posted 8 years ago

I executed a simple SQL query (MySQL if that matters) and rather than returning the response (known to be about 2 million items), I get the error 

JDBC::error: GC overhead limit exceeded

How large a response is allowed? Is there any way to increase the limit?

I can make sub-queries that add up to the total, but it would be optimal if I could just get the answer directly.
POSTED BY: Michael Stern
1 Reply
Sort By:

Try increasing the Java heap sized as in the following (in this case to 4GB:

Needs["JLink`"]

InstallJava[];

ReinstallJava[CommandLine -> "java", JVMArguments -> "-Xmx4048g"]; 

LoadJavaClass["java.lang.Runtime"]; 

ToString[java`lang`Runtime`getRuntime[][maxMemory[]]]
POSTED BY: David Reiss
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract