Kbase P187622: JDBC error "java.lang.OutOfMemoryError" when fetching a large number of records from database settin
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/05/2011 |
|
Status: Unverified
SYMPTOM(s):
JDBC client shows error "java.lang.OutOfMemoryError" when fetching a large number of records from database setting HasFetchLimit to false
Error in SQLEXPLORER.exception file:
Exception at Thu Dec 08 10:02:30 CET 2005: java.lang.OutOfMemoryError
Message (throw): ### Throwable in SQLProcessor run(). ###
Message (excp): null
Stack Trace:
java.lang.OutOfMemoryError
Error on screen: FatalError Encounted
Query is run from SQLExplorer character mode when it fails.
Query executes fine from SQLExplorer GUI mode.
The query is a: SELECT field1, field2 FROM....
Each of the fields can be queried separately without problem
Query should return about 21000 records but stops after 10 000 records
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The default java maximum heap size of 25MB (-mx25m) is exceeding causes the error java.lang.OutOfMemoryError
FIX:
Increase the java heap size on the DLC/properties/JavaTools.properties file under the section [SQLExplorerCLI] as:
For example:
jvmargs=-ms128m -mx512m
Depending on your need, you can have it set to a higher value.