OutOfMemory Error on parsing a big SQL query

58 Views Asked by At

While parsing a big SQL query, I am getting JVM OutOfMemory error. This error raised during SQL query translation using JSqlParser.

The below lines coped from the thread error stack:

Thread 0x648608688
  at java.lang.OutOfMemoryError.<init>()V (Unknown Source)
  at java.util.Arrays.copyOf([Ljava/lang/Object;I)[Ljava/lang/Object; (Unknown Source)
  at java.util.ArrayList.ensureCapacity(I)V (Unknown Source)
  at java.util.ArrayList.addAll(Ljava/util/Collection;)Z (Unknown Source)

The one way to come out of this heap OutOfMemory problem is increasing the configured heap size limit.

Is there any other ways / best practices to improve performance in order to reduce heap memory usage during SQL query translation using JSqlParser?

0

There are 0 best solutions below