Message Boards Message Boards

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

Posted 7 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

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.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract