GC Error (java garbage Collector Error)

Hello everyone,

Hello everyone,i am trying to send a SQL Command to our Database the  result is huge amount of Data and i get GC error the pipeline could not be continue to execute how can i deal with this Error can we divide the result to small pieces to ride of GC Error ?  the Pipeline has the following components   openCon, SQL Command, HTML table Viewer and closeCon. 

We changed (increased) the heap size to influence java garbage collector settings but doesnt help  ?

we use mariadb as DBMS

i get the following Error:

GC overhead limit exceeded
java.lang.OutOfMemoryError: GC overhead limit exceeded



Thanks for your help. 

Raed